Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] pg_migrator not setting values of sequences?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>, 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-16 04:15:12
Message-ID: 15194.1247717712@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Tom Lane wrote:
>> 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?

In 8.5 we'll probably have it go over to treating sequences the same as
other user tables.  What, do you think that'll be the only change
required in pg_migrator's behavior between 8.4 and 8.5?  I think it'll
more likely be down in the noise ...

> Can we run a query that just shifts columns around in the sequence heap
> files we migrated?

Nope.  That's not exposed at the SQL level, even if we allowed ALTER
TABLE on sequences (which I sure hope we don't).

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-07-16 04:16:23
Subject: Re: [GENERAL] pg_migrator not setting values of sequences?
Previous:From: Robert HaasDate: 2009-07-16 04:15:03
Subject: Re: [PATCH] SE-PgSQL/lite rev.2163

pgsql-general by date

Next:From: Tom LaneDate: 2009-07-16 04:16:23
Subject: Re: [GENERAL] pg_migrator not setting values of sequences?
Previous:From: Bruce MomjianDate: 2009-07-16 04:13:14
Subject: Re: [GENERAL] pg_migrator not setting values of sequences?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group