BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP

Поиск
Список
Период
Сортировка
Искать
От
David Fetter
Тема
BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP
Дата
Msg-id
20051117200700.AB2F4F0B15@svr2.postgresql.org
Список
Дерево обсуждения
BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP "David Fetter" <david@fetter.org>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP Jaime Casanova <systemguards@gmail.com>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP David Fetter <david@fetter.org>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play Neil Conway <neilc@samurai.com>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play David Fetter <david@fetter.org>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP David Fetter <david@fetter.org>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP David Fetter <david@fetter.org>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice Bruce Momjian <pgman@candle.pha.pa.us>
Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP David Fetter <david@fetter.org>
The following bug has been logged online:

Bug reference:      2051
Logged by:          David Fetter
Email address:      david@fetter.org
PostgreSQL version: 8.0x
Operating system:   Linux
Description:        CREATE TEMP TABLE AS SELECT doesn't play nice with ON
COMMIT DROP
Details: 

CREATE TEMP TABLE foo
AS SELECT a,b,c
FROM bar
ON COMMIT DROP;

causes a syntax error.  So does 

CREATE TEMP TABLE foo
ON COMMIT DROP
AS SELECT a,b,c
FROM bar
;
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: Jaime Casanova
Дата:
FAQ