Re: BUG #3869: A scenario where pg_dump doesn't dump sequence

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3869: A scenario where pg_dump doesn't dump sequence
Дата
Msg-id 16662.1200162236@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #3869: A scenario where pg_dump doesn't dump sequence  ("guillaume (ioguix) de Rorthais" <ioguix@free.fr>)
Список pgsql-bugs
"guillaume (ioguix) de Rorthais" <ioguix@free.fr> writes:
> I think I found a bug in pg_dump from PostgreSQL 8.1.

> When creating a table with a SERIAL column, thn alter this column as
> smallint, pg_dump doesn't create the sequence anymore.

This is fixed (along with lots of other corner cases for altered serial
columns) in 8.2.  In prior releases, serial columns are best treated
as black boxes.

            regards, tom lane

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

Предыдущее
От: "guillaume (ioguix) de Rorthais"
Дата:
Сообщение: BUG #3869: A scenario where pg_dump doesn't dump sequence
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3860: xpath crashes backend when is querying xmlagg result