Re: [GENERAL] pg_migrator not setting values of sequences? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] pg_migrator not setting values of sequences?
Date
Msg-id 2929.1247527089@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] pg_migrator not setting values of sequences?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [GENERAL] pg_migrator not setting values of sequences?  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Alpha release process
Next
From: KaiGai Kohei
Date:
Subject: Re: [PATCH] SE-PgSQL/lite rev.2163