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