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

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Request new version to support "on commit drop" for create temp table ... as select ?
Дата
Msg-id
26125.1247593106@sss.pgh.pa.us
Ответ на
Re: Request new version to support "on commit drop" for create temp table ... as select ? (Scott Marlowe)
Список
Дерево обсуждения
Request new version to support "on commit drop" for create temp table ... as select ? Emi Lu <emilu@encs.concordia.ca>
Re: Request new version to support "on commit drop" for create temp table ... as select ? Tom Lane <tgl@sss.pgh.pa.us>
Re: Request new version to support "on commit drop" for create temp table ... as select ? Scott Marlowe <scott.marlowe@gmail.com>
Re: Request new version to support "on commit drop" for create temp table ... as select ? Tom Lane <tgl@sss.pgh.pa.us>
Re: Request new version to support "on commit drop" for create temp table ... as select ? Emi Lu <emilu@encs.concordia.ca> 
Scott Marlowe  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 по дате отправления
Предыдущее
От: Scott Marlowe
Дата:
Следующее
От: Emi Lu
Дата:
FAQ