vscode-postgres icon indicating copy to clipboard operation
vscode-postgres copied to clipboard

Published 20 hours ago • verified publisher icon Borvik

not able to access temp table after its created

Open gouriguggari opened this issue 11 months ago • 2 comments

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"

gouriguggari avatar Sep 09 '23 07:09 gouriguggari

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.

Borvik avatar Sep 13 '23 10:09 Borvik

could you suggest a workaround for this if any?

gouriguggari avatar Feb 08 '24 08:02 gouriguggari