Re: CREATE TEMPORARY TABLE AS ... ON COMMIT? - Mailing list pgsql-general

From Neil Conway
Subject Re: CREATE TEMPORARY TABLE AS ... ON COMMIT?
Date
Msg-id 1098315155.6602.167.camel@localhost.localdomain
Whole thread Raw
In response to CREATE TEMPORARY TABLE AS ... ON COMMIT?  (Thomas F.O'Connell <tfo@sitening.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: table size/record limit
Next
From: "Ed L."
Date:
Subject: Invalid page header