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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers