BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can
Дата
Msg-id 200706220155.l5M1toH9061867@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      3403
Logged by:          Jasen Betts
Email address:      jasen@treshna.com
PostgreSQL version: 8.2.0
Operating system:   window XP (vmware)
Description:        ver 8.2 can't add serial column to temp table,but 8.1
can
Details:

gymmaster=# select version();
                                         version

--------
----------------------------------------------------------------------------
------
 PostgreSQL 8.2.0 on i686-pc-mingw32, compiled by GCC cc.exe (GCC) 3.4.2
(mingw-special)
(1 row)
template1=# create temp table foo ( x text);
CREATE TABLE
template1=# alter table foo add column y text ;
ALTER TABLE
template1=# alter table foo add column id serial;
NOTICE:  ALTER TABLE will create implicit sequence "foo_id_seq" for serial
colum
n "foo.id"
ERROR:  relation "public.foo" does not exist
template1=#


this worked in version 8.1.8 (linux)

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID'
Следующее
От: Zdenek Kotala
Дата:
Сообщение: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can