Resolve "TABLE TEMP_DISK_FXIDS is missing in the schema but is defined in the catalogue database when cta-restore-deleted-files is run with postgreSQL"
Merged
requested to merge 161-table-temp_disk_fxids-is-missing-in-the-schema-but-is-defined-in-the-catalogue-database-when into main
All threads resolved!
When createAndPopulateTempTableFxid
is run with PostgreSQL, the table will not be removed automatically, as the case is with OracleDB. Therefore, the temporary table should be removed after the commit of the query.
Closes #161 (closed)
Edited by Lasse Tjernaes Wardenaer
Merge request reports
Activity
Filter activity
added Operator Tools label
assigned to @lwardena
added 1 commit
- 2ecfe3d7 - change "select tablename" query to use current_schema()
added 2 commits
added 6 commits
-
f3917f38...160a1743 - 5 commits from branch
main
- 432cab7e - Merge branch 'main' into...
-
f3917f38...160a1743 - 5 commits from branch
requested review from @dhsmith
- Resolved by Lasse Tjernaes Wardenaer
Hi Lasse. Do you think you could remove the terminating semicolon from the SELECT statement?; the rdbms layer doesn't need it as it's intended for single statements and most of the other statements in the rdbms wrapper/catalogue don't include the ';' at the end, so I thought be could keep this statement similar.
Please register or sign in to reply