Problem with sequences on a reload of a pg_dump file

Поиск
Список
Период
Сортировка
От Sean Shanny
Тема Problem with sequences on a reload of a pg_dump file
Дата
Msg-id 40B4F765.5000904@earthlink.net
обсуждение исходный текст
Ответы Re: Problem with sequences on a reload of a pg_dump file  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Problem with sequences on a reload of a pg_dump file  (Yannick LOUVET <y.louvet@atolcd.com>)
Список pgsql-general
To all,

We dumped our instance from a 7.4.2 instance compiled with a block size
of 32k running on OSX 10.3.3 server..  We loaded this dump on Fedora
2.6.5-1.358smp running postgresql 7.4.2 compiled with the standard 8k
blocks size.

My problem is that all the sequences were reset to start a 1. :-(   Did
I do something wrong as this has never happened before?  Also, can I
simply figure out what the  next value should be and manually update the
last_value column in each affected sequence?

Thanks.

--sean

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

Предыдущее
От: Ericson Smith
Дата:
Сообщение: Re: Postgresql Logging
Следующее
От: "Lee Harr"
Дата:
Сообщение: Re: Remote X viewing of pgaccess