You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
PostgreSQL 14.10 on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
Was happy about the free version and just bought the premium package. Then i instantly found a bug 🤣
I'm creating multiple temporary tables with postgres and then joining them to export these as csv. This example has only one, but this is still reproducable:
DROPTABLE IF EXISTS network_params_aggr_numeric;
SELECT DISTINCT
network,
value as"numeric"
INTO TEMPORARY TABLE network_params_aggr_numeric
FROM network_params
WHERE1=1AND network >0and network IN (SELECT code FROM networks)
AND param_type IN (3);
SELECTn.codeAS"code",
np.numericAS"numeric"FROM networks n
JOIN network_params_aggr_numeric np ONn.code=np.networkWHEREn.code>0
Now we have two scenarios:
Export without "Remove Pagination SQL" to Editor -> this is working ✔
Export with "Remove Pagination SQL" to Editor -> throws an Error ❌ -> "2024-01-05 11:53:20 Cannot read properties of null (reading 'name')"
I guess the "Remove Pagination SQL" is opening a second session, so that the temporary tables are not available.
Of course I can create persistent tables and then just drop them, but that is what the temporary tables are for.
The text was updated successfully, but these errors were encountered:
Was happy about the free version and just bought the premium package. Then i instantly found a bug 🤣
I'm creating multiple temporary tables with postgres and then joining them to export these as csv. This example has only one, but this is still reproducable:
Now we have two scenarios:
I guess the "Remove Pagination SQL" is opening a second session, so that the temporary tables are not available.
Of course I can create persistent tables and then just drop them, but that is what the temporary tables are for.
The text was updated successfully, but these errors were encountered: