Describe the bug
A very basic postgres DB that uses custom user named root, which was explicitly granted permissions on a database and schema, does not see anything at all when expanding the connection. The arrow simply changes direction from pointing right to pointing down, and nothing else changes. There are no errors in the logs. I can run queries verifying the user can access the database, schema, and tables throughg the SQLTools connection.
This only seems to be affecting a very specific DB. If I create another DB I can connect and I can see the schemas in the tree.
To Reproduce
Steps to reproduce the behavior:
Connect to this very specific DB
Expected behavior
I see the schemas.
Desktop (please complete the following information):
SQLTools Version v0.27.1
VS Code Version: 1.78.0
OS: Windows, using a developer container on a debian system
Driver:
[ X ] PostgreSQL/Redshift
[ ] MySQL/MariaDB
[ ] MSSQL/Azure
[ ] SQLite
[ ] Other? Which...
Database version: Postgres 15
Additional context
Downgrading to the previous version of SQLTools, the postgres / cockroach driver, and Postgres to version 14 do not resolve the issue. Renaming the schema does not resolve the issue. Creating a new user does not resolve the issue. Reloading does not resolve the issue.
SQLTools logs:
[1683332039412] INFO (ext): EXECUTING COMMAND => sqltools.getConnections
[1683332039414] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1683332039447] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem
[1683332039448] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest
Describe the bug A very basic postgres DB that uses custom user named
root, which was explicitly granted permissions on a database and schema, does not see anything at all when expanding the connection. The arrow simply changes direction from pointing right to pointing down, and nothing else changes. There are no errors in the logs. I can run queries verifying the user can access the database, schema, and tables throughg the SQLTools connection.This only seems to be affecting a very specific DB. If I create another DB I can connect and I can see the schemas in the tree.
To Reproduce Steps to reproduce the behavior:
Expected behavior I see the schemas.
Desktop (please complete the following information):
Additional context Downgrading to the previous version of SQLTools, the postgres / cockroach driver, and Postgres to version 14 do not resolve the issue. Renaming the schema does not resolve the issue. Creating a new user does not resolve the issue. Reloading does not resolve the issue.
SQLTools logs: