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
Error when disconnecting from Postgres 15.0 connection #334
Comments
+1 |
1 similar comment
+1 |
I fixed it locally. change db.datlastsysoid, to 0 as datlastsysoid, in the sql text. |
+1 - Thank you! - I was getting this when trying to expand databases in tree. |
This was really helpful, thank you! For anyone for whom this doesn't fix it, note that you may have to do a little more depending on... factors I don't really understand as a Postgres newbie 🤣 See my comment here. |
This fixed my issue today - thank you! |
how to open this m really not getting how to fix using this solution |
@sanyog2491 - if you navigate to this directory (easiest way is to open File Explorer and past it into the address bar). %USERPROFILE%.azuredatastudio\extensions\microsoft.azuredatastudio-postgresql-0.2.7\out\ossdbtoolsservice\Windows\v1.5.0\pgsqltoolsservice\lib\pgsmo\objects\database\templates+default Edit the file "nodes.sql" and you should see a line referencing "datlastsysoid" - you want to change that line to look like this: 0 as datlastsysoid, Save the file and then open Azure Data Studio again and the issue should be resolved. |
For MacOS this can be found at
|
@RachelAmbler @Aidan-Chang thanks it fixed the problem for me too |
Tracking from #357. Closing the issue |
From Azure Data Studio:
On the Postgres side:
The text was updated successfully, but these errors were encountered: