Carl R. Brune wrote:
I should have added that I want to make further use of the temporary table after the COMMIT -- the rollback approach you propose makes it go away.
In which case the transaction isn't READONLY. You have two options: CREATE TEMPORARY TABLE ... AS SELECT ... BEGIN READONLY; ... COMMIT;Or, create a user with only-read permissions on your database and connect as that user.
-- Richard Huxton Archonet Ltd
