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

Re: BUG #1883: Renaming a schema leaves inconsistent sequence

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Kouber Saparev <postgresql(at)saparev(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1883: Renaming a schema leaves inconsistent sequence
Date: 2005-09-23 04:12:23
Message-ID: 29560.1127448743@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> On Thu, Sep 22, 2005 at 10:29:21PM -0400, Tom Lane wrote:
>> (wanders off, wondering if a "regclass" literal value would help ...)

> Wouldn't it be easy to create a nextval(oid) function, and have SERIAL
> emit that instead?

Well, for one thing, "nextval(583726163)" isn't likely to dump and
restore nicely.  Making the literal be type regclass rather than bare
OID will probably help that, but I'm not sure it's a 100% solution.
If I recall the previous discussions correctly there were still some
gotchas :-(

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-09-23 04:35:02
Subject: Re: BUG #1883: Renaming a schema leaves inconsistent sequence
Previous:From: Bruce MomjianDate: 2005-09-23 03:42:30
Subject: Re: SQL/XML public functions documentation for PostgreSQL

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-09-23 04:35:02
Subject: Re: BUG #1883: Renaming a schema leaves inconsistent sequence
Previous:From: Alvaro HerreraDate: 2005-09-23 03:12:28
Subject: Re: BUG #1883: Renaming a schema leaves inconsistent sequence

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