Re: [GENERAL] pg_migrator not setting values of sequences?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] pg_migrator not setting values of sequences?
Дата
Msg-id 2929.1247527089@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] pg_migrator not setting values of sequences?  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: [GENERAL] pg_migrator not setting values of sequences?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Tilmann Singer wrote:
>> However, all of the sequences were at the initial values and not
>> bumped up to the last used value as I would have expected. The first
>> nextval call on any sequence in the migrated 8.4 database always
>> returned 1.

> Wow, that is also surprising.  I am going to have to run some tests to
> find the cause, but it certainly is not intended.

Looks like pg_migrator neglects to include relkind 'S' in the set of
tables that it needs to physically migrate.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Alpha release process
Следующее
От: KaiGai Kohei
Дата:
Сообщение: Re: [PATCH] SE-PgSQL/lite rev.2163