Tilmann Singer wrote: > I tried the latest pg_migrator > (http://pgfoundry.org/frs/download.php/2291/pg_migrator-8.4.tgz) to > migrate a database from an 8.3.7 to an 8.4.0 cluster. It finished with > a success message, and the schema and all tables seem to have been > migrated correctly. > > 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. > > Is this behaviour intended for some reason, or a bug?
[ CC to hackers.] Wow, that is also surprising. I am going to have to run some tests to find the cause, but it certainly is not intended. -- 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