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

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, 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 18:52:38
Message-ID: 4A5CD3F6.8030505@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Got it. Thank you Tom!

> Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
>> 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?
>
> Your syntax is wonky -- switch the clause order.
> http://www.postgresql.org/docs/8.3/static/sql-createtableas.html
>
> regards, tom lane
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Landscheidt 2009-07-16 21:19:56 Comparing a string against an XPath result set
Previous Message Tom Lane 2009-07-14 17:38:26 Re: Request new version to support "on commit drop" for create temp table ... as select ?