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
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.
Edited by Lasse Tjernaes Wardenaer