pg_migrator not setting values of sequences? - Mailing list pgsql-general

From Tilmann Singer
Subject pg_migrator not setting values of sequences?
Date
Msg-id 20090713220112.GF7933@klana.box
Whole thread Raw
Responses Re: pg_migrator not setting values of sequences?
List pgsql-general
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?


Til

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Benetl, a free ETL tool for files using postgreSQL, is out in version 2.9
Next
From: Jamie Fox
Date:
Subject: Re: large object does not exist after pg_migrator