Tom Lane wrote: > Bruce Momjian <br...@momjian.us> writes: > > Tilmann Singer wrote: > >> 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. > > > Wow, that is also surprising. I am going to have to run some tests to > > find the cause, but it certainly is not intended. > > Looks like pg_migrator neglects to include relkind 'S' in the set of > tables that it needs to physically migrate.
Thanks, I have fixed pg_migrator with the attached patch. Once we find the cause of the lovacuum problem, I will make a new pg_migrator release. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Index: info.c =================================================================== RCS file: /cvsroot/pg-migrator/pg_migrator/src/info.c,v retrieving revision 1.17 retrieving revision 1.18 diff -c -c -r1.17 -r1.18 *** info.c 30 Jun 2009 22:01:12 -0000 1.17 --- info.c 14 Jul 2009 02:34:59 -0000 1.18 *************** *** 343,349 **** STRINGIFY(FirstNormalObjectId) " " " AND " " (relkind = 'r' OR relkind = 't' OR " ! " relkind = 'i') " "GROUP BY c.oid, n.nspname, c.relname, c.relfilenode," " c.reltoastrelid, t.spclocation, " " n.nspname " --- 343,349 ---- STRINGIFY(FirstNormalObjectId) " " " AND " " (relkind = 'r' OR relkind = 't' OR " ! " relkind = 'i' OR relkind = 'S') " "GROUP BY c.oid, n.nspname, c.relname, c.relfilenode," " c.reltoastrelid, t.spclocation, " " n.nspname "
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers