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

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>
Cc: PgSql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: CREATE TEMPORARY TABLE AS ... ON COMMIT?
Date: 2004-10-20 23:32:35
Message-ID: 1098315155.6602.167.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2004-10-20 23:34:46 Invalid page header
Previous Message Dennis Gearon 2004-10-20 23:30:11 table size/record limit