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

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

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 03:12:28
Message-ID: 20050923031227.GK31459@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
On Thu, Sep 22, 2005 at 10:29:21PM -0400, Tom Lane wrote:

> To my mind the appropriate fix is to come up with some arrangement
> that allows the stored form of NEXTVAL(seq) to specify the referenced
> sequence directly (by OID) rather than as a text string.  There are some
> speculations about this in the archives, but no really workable solution
> yet.
> 
> (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?

-- 
Alvaro Herrera                         Architect, http://www.EnterpriseDB.com
"Endurecerse, pero jamás perder la ternura" (E. Guevara)

In response to

Responses

pgsql-hackers by date

Next:From: Pavel StehuleDate: 2005-09-23 03:30:35
Subject: SQL/XML public functions documentation for PostgreSQL 8.2
Previous:From: Bruce MomjianDate: 2005-09-23 03:05:49
Subject: Re: [HACKERS] How to determine date / time of last postmaster

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-09-23 04:12:23
Subject: Re: BUG #1883: Renaming a schema leaves inconsistent sequence
Previous:From: Bruce MomjianDate: 2005-09-23 02:59:43
Subject: Re: BUG #1883: Renaming a schema leaves inconsistent sequence

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