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 :-(
Uh, how is this going to behave in 8.5? Do we still dump sequences, and if so, aren't we heading down the road of dumping stuff only because a previous release needed it? Can we run a query that just shifts columns around in the sequence heap files we migrated? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
