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

Re: [PATCHES] Proposed patch for sequence-renaming problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Michael Paesold <mpaesold(at)gmx(dot)at>,PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [PATCHES] Proposed patch for sequence-renaming problems
Date: 2005-09-28 17:25:23
Message-ID: 7547.1127928323@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Michael Paesold wrote:
>> Since the NEXT VALUE FOR syntax has a special meaning, would it be better to
>> support the oracle-style syntax sequence.nextval for now (and use the 
>> ::regclass for this)? I am not sure how easy that is considering 
>> schema.sequence.nextval.

> Yes, that is the direction I thought we were going.

We are further away than ever from being able to support that:

regression=# select seq.nextval;
ERROR:  missing FROM-clause entry for table "seq"

Given that that proposal has been on the TODO list for years, and no one
has ever offered any workable way to implement it, I think waiting until
a way appears is equivalent to saying none of this will ever get fixed.
I'm not prepared to accept "fix it in 8.2" unless you can present an
implementation plan that can fix it in 8.2, and "use the Oracle syntax"
isn't a plan.

Moreover, providing a regclass-based nextval function doesn't foreclose
us from supporting the Oracle syntax if someone does have a bright idea
about it.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-09-28 17:49:05
Subject: Re: [PATCHES] Proposed patch for sequence-renaming problems
Previous:From: Bruce MomjianDate: 2005-09-28 16:58:01
Subject: Re: [PATCHES] Proposed patch for sequence-renaming problems

pgsql-patches by date

Next:From: Tom LaneDate: 2005-09-28 17:49:05
Subject: Re: [PATCHES] Proposed patch for sequence-renaming problems
Previous:From: Bruce MomjianDate: 2005-09-28 16:58:01
Subject: Re: [PATCHES] Proposed patch for sequence-renaming problems

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