not able to access temp table after its created

[gouriguggari]

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]

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]

could you suggest a workaround for this if any?

[srearl]

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