Scott Marlowe <scott.marl...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
