By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,773 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,773 IT Pros & Developers. It's quick & easy.

CREATE TEMPORARY TABLE AS ... ON COMMIT?

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.