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
Cannot open database list (Error: Failed to expand node) #333
Comments
I also get this for Postgres 15, but not for 14, with ADS 1.39.1. When expanding the databases node, the following command is run:
The error given is that db.datlastsysoid isn't a valid column anymore. |
I am also having this issue. |
This fixed the error for me. #334 |
I'm hitting this error. Also, the System Databases folder hits the same issue. Using the fix from above did work though. |
Facing the same issue. I can connect and run queries but this error occurs for Databases and System Databases PostgreSQL 15 The fix cited earlier on #334 did not work for me |
Occurs when I try to expand databases on a local server. The fix from #334 got me part of the way there, but, possibly due to server configuration (I'm new to Postgres), I had to put double quotes around column aliases in {#
# pgAdmin 4 - PostgreSQL Tools
#
# Copyright (C) 2013 - 2017, The pgAdmin Development Team
# This software is released under the PostgreSQL Licence
#}
SELECT
db.oid as "oid",
db.datname AS "name",
ta.spcname as "spcname",
db.datallowconn as "datallowconn",
0 as "datlastsysoid",
has_database_privilege(db.oid, 'CREATE') as "cancreate",
datdba as "owner",
db.datistemplate as "datistemplate",
has_database_privilege(db.datname, 'connect') as "canconnect",
datistemplate as "is_system"
FROM
pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace = ta.oid
{% if did %}
WHERE db.oid = {{ did|qtLiteral }}::OID
{% elif last_system_oid %}
WHERE db.oid > {{ last_system_oid }}::OID
{% endif %}
ORDER BY datname; |
Having the same issue with the same setup as @NarishSingh. Any Ideas on how to fix this? thanks |
@solmazeradat Did you see my comment above? I had to quote the column aliases, which I think is some config thing specific to certain installations of Postgres. Give it a try, maybe? |
For anyone that may not be aware, if you're on a Mac, the path to the nodes.sql that @jammerware supplied a correction to can be found at:
|
Thanks this worked |
Great, somehow I figure out the issue Thanks! |
This bug's workaround is inconvenient and the fix appears to be straightforward. Would love to have this fixed in an upcoming update. This comment fixed my issue but I pretty much can't use ADS until I modify that file. |
It's also happening when I try to expand Indexes |
Couldn't get the workaround to work so used pgAdmin for the time being. |
Tracking from #357, closing the issue |
Using PostgreSQL 15.0
MacOS Monterey 12.6
Azure Data Studio 1.39.1
Unable to open the list of databases (silently fails on left-click).
Error pops up when right clicking the database list and hitting Refresh.
The text was updated successfully, but these errors were encountered: