postgres introspection error

[BobcGn]

Error:
Cannot read properties of undefined (reading 'rows')

---

VSCode Version: 1.138.0
Extension Version: 1.38.5
OS: darwin
Arch: arm64
Database Version: PostgreSQL 18.6 (Debian 18.6-1.pgdg13 2) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit - 18.6 (Debian 18.6-1.pgdg13 2)

[mikeburgh]

Thanks for the report. That error is coming from the schema introspection. I spun up a Postgres 18.6 server here to reproduce it and a stock database loads fine, so it looks tied to something specific about your database or the role you connect with.

Can you try two things:

1. Edit the connection, open the Advanced section, and turn on "Progressive Loading". That path loads objects on demand and can handle failing queries.
2. Turn on debug logging and reconnect so I can see which query is the problem once you enable progressive loading. To enable it: open View > Output, pick DBCode in the output channel dropdown, click "Set Log Level" in the panel toolbar and choose Debug. Then expand or refresh the connection and paste what shows up in that DBCode output.

Steps with screenshots are here: https://dbcode.io/docs/help-support/debug

With progressive loading on, the log will name the exact query that fails, progressive loading means the introspection will pass, and the explorer will show tables etc, but there will still be a failing query underneath.