Thread: CREATE TEMPORARY TABLE AS ... ON COMMIT?

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

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