| From: | "Tilmann Singer" <tils(at)tils(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_migrator not setting values of sequences? |
| Date: | 2009-07-13 22:01:12 |
| Message-ID: | 20090713220112.GF7933@klana.box |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jamie Fox | 2009-07-13 22:21:39 | Re: large object does not exist after pg_migrator |
| Previous Message | Michael Glaesemann | 2009-07-13 21:45:06 | Re: Benetl, a free ETL tool for files using postgreSQL, is out in version 2.9 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2009-07-13 22:02:54 | Re: Mostly Harmless: c++reserved - patch 1 of 4 |
| Previous Message | Peter Eisentraut | 2009-07-13 21:55:33 | Re: Mostly Harmless: c++configure - patch 3 of 4 |