Export result set from temp tables error

[ems2811]

System information:

• Win10 Pro
• DBeaver 21.3.4 (same problem in 21.3.3)
• No additional extensions

Connection specification:

• PostgreSQL 9.5
• Default postgresql driver
• No tunnels or proxies

Describe the problem you're observing:

Error on export result set from temp table

Steps to reproduce, if exist:

Execute query below and try export to SQL or TXT format

create temp table tt as
select 1 as id;

select *
from tt;

Include any warning/errors/backtraces from the logs

log
dbeaver-debug.log

[uslss]

@ems2811 probably, you've got Open new connection(s) enabled in properties?

In this case the temporary table doesn't exist in the newly opened connection

[ems2811]

Really. I didn't think about that. Thank you.

[dstj]

@uslss

I don't know if this is by SQL design or a bug in DBeaver v24.2.3, but it does not work when the whole thing is running inside a transaction. Well, it works only once...

Reproduction

BEGIN TRANSACTION;

CREATE TEMP TABLE tmp1 AS
SELECT 1;

CREATE TEMP TABLE tmp2 AS
SELECT 2;

SELECT * FROM tmp1;
SELECT * FROM tmp2;

-- ROLLBACK;

(Please note that the ROLLBACK is commented out (I'm running a migration test).)

Exporting the results of the first tmp1 works, then exporting the results of tmp2 errors with:

SQL Error [42P01]: ERROR: relation "tmp2" does not exist
Position: 15

Trying to export the tmp1 results a second time also yields the error mind you.

Do you know if that is expected or a bug? I really need to find a way to export the results of my 8-9 temp tables during this data migration.

Thanks.