From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
Cc:
Bruce Momjian <bruce(at)momjian(dot)us>, Tilmann Singer <tils(at)tils(dot)net>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: [GENERAL] pg_migrator not setting values of sequences?
Date:
2009-07-15 16:10:41
Message-ID:
23975.1247674241@sss.pgh.pa.us (view raw or flat )
Thread:
2009-07-13 22:01:12 from "Tilmann Singer" <tils(at)tils(dot)net>
2009-07-13 22:29:36 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-13 23:18:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-07-14 02:37:02 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-15 16:04:29 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2009-07-15 16:10:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-07-15 16:23:08 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-07-16 02:03:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-07-16 04:07:52 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-16 04:11:19 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-16 04:13:14 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-16 04:16:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-07-16 08:29:04 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-07-16 10:36:14 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-16 04:09:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-16 04:15:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-07-16 04:28:47 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-16 10:55:48 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-07-16 12:53:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-07-16 18:58:20 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-07-13 22:30:17 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-general pgsql-hackers
Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)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
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2009-07-15 16:17:29Subject : Re: Add encoding support to COPY Previous :From : David BlewettDate : 2009-07-15 16:08:32Subject : Re: Add encoding support to COPY
pgsql-general by date
Next :From: Alvaro HerreraDate: 2009-07-15 16:23:08Subject : Re: [GENERAL] pg_migrator not setting values ofsequences?Previous :From : Tom LaneDate : 2009-07-15 16:05:38Subject : Re: initdb --locale=LATIN1 fails on Windows
