Re: Request new version to support "on commit drop" for create temp table ... as select ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Request new version to support "on commit drop" for create temp table ... as select ?
Date: 2009-07-14 16:47:30
Message-ID: 25173.1247590050@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Emi Lu <emilu(at)encs(dot)concordia(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2009-07-14 17:33:21 Re: Request new version to support "on commit drop" for create temp table ... as select ?
Previous Message Surajit Bhattacharjee 2009-07-14 15:21:37 Re: function returning a cursor and a scalar