CREATE TEMPORARY TABLE AS ... ON COMMIT?

[Thomas F.O'Connell]

Is the ON COMMIT syntax available to temporary tables created using the
CREATE TABLE AS syntax? If not, is there a way to drop such a table at
the end of a transaction?

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Neil Conway]

On Thu, 2004-10-21 at 06:40, Thomas F.O'Connell wrote:

Is the ON COMMIT syntax available to temporary tables created using the
CREATE TABLE AS syntax?
No, but it should be. There's a good chance this will be in 8.1
If not, is there a way to drop such a table at
the end of a transaction?

DROP TABLE :)

-Neil

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster