Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres server displays nothing in the connection explorer when expanded #1144

Open
4 tasks
JamesHutchison opened this issue May 6, 2023 · 0 comments
Open
4 tasks
Labels

Comments

@JamesHutchison
Copy link

JamesHutchison commented May 6, 2023

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:

  1. 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant