DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=P3H/xiTHDT1f+BSprnxgE8GUMiCrthDk7dtMLzmjrbWbFD9tk/SYc8gPEXiszrpxV4
	jLbrwVU2p9bvKluf6Xvg7HGLNX0z3DFAaiMU92y/QcLDGxuBx5wulJbRX4SWuUSXTiZ2
	VmSOQ+t2aVUSpxC8TJGBH5RIyEvXKVbN0pjYY=
MIME-Version: 1.0
In-Reply-To: <25173.1247590050@sss.pgh.pa.us>
References: <4A5C9F55.5050305@encs.concordia.ca>
	<25173.1247590050@sss.pgh.pa.us>
Date: Tue, 14 Jul 2009 11:33:21 -0600
Message-ID: <dcc563d10907141033ja1783d7y7fe7599979f7599@mail.gmail.com>
Subject: Re: Request new version to support "on commit drop" for create
	temp table ... as select ?
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: emilu@encs.concordia.ca, pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Jul 14, 2009 at 10:47 AM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> 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. =A0Didn't you notice that message was from 2005?

That's what I thought, but

create temp table xyz as select * from abc on commit drop;

still fails on 8.3.  Was this fixed in 8.4 or is my syntax wonky?