Re: [HACKERS] sequences - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] sequences
Date
Msg-id 34F4E427.75B79BD3@sable.krasnoyarsk.su
Whole thread Raw
In response to sequences  (Brett McCormick <brett@work.chicken.org>)
Responses Re: [HACKERS] sequences  ("Michael J. Rogan" <mrogan@fpelectronics.com>)
List pgsql-hackers
Brett McCormick wrote:
>
> Are there any plans to implement oid-style functionality for
> sequences, such as returning the nextval in the result tuple somehow?
>
> Is it at all possible to implement?  That is one very nice thing about
> using oid instead, is that it comes back in PQoidStatus.  I probably
> won't stop using oids until this is possible (i've got my own restore
> which "preserves" (i.e. renumbers) oid references)

Not possible - sequences are just "a gear", user can use more than
one sequences in inserts, etc...

But we could return PRIMARY KEY of affected tuple if it exists!
I kept this feature in mind when thought about removing OID...

Comments ?

Vadim

pgsql-hackers by date:

Previous
From: Brett McCormick
Date:
Subject: alpha/64bit & mkoidname problem
Next
From: Bruce Momjian
Date:
Subject: Re: [PORTS] alpha/64bit & mkoidname problem