search

Borvik / vscode-postgres

PostgreSQL extension for vscode providing explorer, highlighting, diagnostics, and intellisense
MIT License
228 stars 49 forks source link

not able to access temp table after its created #238

Open gouriguggari opened 1 year ago

gouriguggari commented 1 year ago

I created a temp table and it ran successfully, but when I try to query from the temp table it throws an error "relation TEMP_TABLE_NAME does not exist"

Borvik commented 1 year ago

this would likely be due to the fact the the extension does not keep a persistent connection to the database open.

that was a design decision to allow maintenance on the database that requires connections be disconnected, without have to remember which editor/window is keeping the connection open.

gouriguggari commented 9 months ago

could you suggest a workaround for this if any?

srearl commented 1 month ago

Hi @gouriguggari just checking to see if you or others might have identified a workaround so as to be able to access temporary tables.