Re: read only transaction, temporary tables

Thanks for the information clarifications.

Carl B.

On Tue, 8 Aug 2006, 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.
>
> 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
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>