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 26125.1247593106@sss.pgh.pa.us
Whole thread Raw
In response to Re: Request new version to support "on commit drop" for create temp table ... as select ?  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Request new version to support "on commit drop" for create temp table ... as select ?
List pgsql-sql
Tree view 
Scott Marlowe <scott.marlowe@gmail.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

pgsql-sql by date:

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