Re: [GENERAL] CREATE TEMPORARY TABLE AS ... ON COMMIT?

2004-10-20 Thread 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?

[GENERAL] CREATE TEMPORARY TABLE AS ... ON COMMIT?

2004-10-20 Thread 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, Sui