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

Alvaro Herrera wrote:
> Bruce Momjian wrote:
> 
> > Something is certainly wrong.  Did we change sequence table format from
> > 8.3 to 8.4?
> 
> 8.3 does not have start_value.

Looking at an invalidly-migrated sequence's columns:
regression=> \d serialtest_f2_foo      Sequence "public.serialtest_f2_foo"    Column     |  Type   |
Value---------------+---------+---------------------sequence_name | name    | serialtest_f2_foo last_value    | bigint
|3 start_value   | bigint  | 1 increment_by  | bigint  | 9223372036854775807 max_value     | bigint  | 1 min_value
|bigint  | 1 cache_value   | bigint  | 0 log_cnt       | bigint  | 25387551686912 is_cycled     | boolean | f is_called
   | boolean |
 

Should pg_migrator just pull the misaligned values and do an ALTER
SEQUENCE/seval() to fix it, or create a script to do that?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +