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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
