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