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.
Carl Brune
On Tue, 8 Aug 2006, John DeSoi wrote:
>
> On Aug 8, 2006, at 1:25 PM, Carl R. Brune wrote:
>
>> I recently tried to do something like the following
>>
>> BEGIN READONLY;
>> ...
>> CREATE TEMPORARY TABLE ABC AS SELECT ...
>> ...
>> COMMIT;
>>
>> and it failed because CREATE is not allowed within a read-only
>> transaction. The select is something long and complicated (pieced
>> together with php) and I'm just trying to be careful. What other
>> alternatives are there for accomplishing this? Preferably
>> simple ones...
>
>
> How about:
>
> BEGIN;
> ....
> CREATE TEMPORARY TABLE ABC AS SELECT ...
> ....
> ROLLBACK;
>
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
