CREATE TEMPORARY TABLE AS ... ON COMMIT?

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: PgSql General <pgsql-general(at)postgresql(dot)org>
Subject: CREATE TEMPORARY TABLE AS ... ON COMMIT?
Date: 2004-10-20 20:40:22
Message-ID: 4378634B-22D8-11D9-A5E5-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Barnard 2004-10-20 20:59:29 Re: OID and PK/FK KEYS
Previous Message Josh Close 2004-10-20 20:36:16 Re: how much ram do i give postgres?