Zdenek Kotala <zdenek.kot...@sun.com> writes: > I think you don't need transfer sequence table, because pg_dump should > create DDL command (CREATE SEQUENCE) which should create new nice > sequence relation.
Yeah, but pg_dump is doing a schema-only dump so it doesn't transfer the current state of the sequence. The most effective solution might be to revert the change in pg_migrator and instead have pg_dump interpret --binary-upgrade --schema-only to include the data for sequences. It seems ugly as sin though :-( regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers