Postgres Pro
Downloads
Home   >   mailing lists

Re: Request new version to support "on commit drop" for create temp table ... as select ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Request new version to support "on commit drop" for create temp table ... as select ?
Date
Msg-id 25173.1247590050@sss.pgh.pa.us
Whole thread Raw
In response to Request new version to support "on commit drop" for create temp table ... as select ?  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: Request new version to support "on commit drop" for create temp table ... as select ?
List pgsql-sql
Tree view 
Emi Lu <emilu@encs.concordia.ca> writes:
> I googled to find that "on commit drop" does not support:

> (a) create temp table as select * from table1 where 1<>2;
> http://archives.postgresql.org/pgsql-sql/2005-09/msg00153.php

Ah, the pitfalls of believing that the first google hit you get
is authoritative.  Didn't you notice that message was from 2005?
        regards, tom lane

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Request new version to support "on commit drop" for create temp table ... as select ?
Next
From: Scott Marlowe
Date:
Subject: Re: Request new version to support "on commit drop" for create temp table ... as select ?