possible bug with sequences

Поиск
Список
Период
Сортировка
От Victor Sudakov
Тема possible bug with sequences
Дата
Msg-id c48au4$b0a$1@mpeks.tomsk.su
обсуждение исходный текст
Ответы Re: possible bug with sequences  (Daniel Rubio <drubior@tinet.org>)
Список pgsql-admin
Colleagues,

What is the internal difference between an implicit sequence (created
automatically by the "serial" data type) and an explicit sequence
(created manually)?

I think I have hit something that can qualify as a bug. How to
reproduce:

============== cut here =============================

reports=# CREATE TABLE sometable (id serial, name text);
NOTICE:  CREATE TABLE will create implicit sequence "sometable_id_seq" for "serial" column "sometable.id"
CREATE TABLE
reports=# ALTER TABLE sometable RENAME TO othername;
ALTER TABLE
reports=# \d othername
                           Table "admin.othername"
 Column |  Type   |                        Modifiers
--------+---------+----------------------------------------------------------
 id     | integer | not null default nextval('admin.sometable_id_seq'::text)
 name   | text    |

============== cut here =============================

Voila! pg_restore will now return an error on trying to execute
SELECT pg_catalog.setval('sometable_id_seq', 4, true);
because this sequence has not been created either explicitly or implicitly!

It is 100% reproducible on postgresql-7.4.1

--
Victor Sudakov,  VAS4-RIPE, VAS47-RIPN
2:5005/149@fidonet http://vas.tomsk.ru/

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

Предыдущее
От: "Anjan Dave"
Дата:
Сообщение: Re: Use 7.4.1's pg_dump in 7.2.4?
Следующее
От: "Fernando B"
Дата:
Сообщение: Using windows authentication to connect to postgress