Tom Lane wrote: > 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 :-(
It seems cleaner to have a pg_dump --dump-all-sequences or some such. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
