Re: BUG #1513: pg_dump -t doesn't include sequences for pre-v8-created tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1513: pg_dump -t doesn't include sequences for pre-v8-created tables
Дата
Msg-id 8884.1111703618@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1513: pg_dump -t doesn't include sequences for pre-v8-created tables  ("Chris Hutchinson" <hutchinson.chris@gmail.com>)
Список pgsql-bugs
"Chris Hutchinson" <hutchinson.chris@gmail.com> writes:
> pg_dump -t includes SERIAL column sequence details for the dumped table when
> the table has been created in v8 postgresql.

> Tables migrated from an earlier pg version aren't being dumped with their
> sequence details. (These tables were created in 7.1, and migrated through
> 7.3, 7.4 and 8.0)

Yup.  You might try the contrib/adddepend tool to fix this.

            regards, tom lane

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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: BUG #1532: typecast problem between arrays of an int8
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1532: typecast problem between arrays of an int8 derived datatype and varchar[]