
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)

--brett

Wed, 25 Feb 1998 18:56:36 -0800 (PST)
Brett McCormick <brett@work.chicken.org>
sequences
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

Thu, 26 Feb 1998 10:40:23 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] sequences

> 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 ?

This would be very useful.  I never did like the idea of using OID as 
reference so a way to get the PIMARY KEY would be  A GOOD THING(tm).

Michael

BTW: I could have sworn the first thing I tried was to grant select on the 
sequence I was using when it complianed about access.

> 
> Vadim
> 
> 

* Michael J. Rogan,  Network Administrator,   905-624-3020 *
* Mark IV Industries, F-P Electronics & I.V.H.S. Divisions *
* mrogan@fpelectronics.com                 mrogan@ivhs.com *

Thu, 26 Feb 1998 17:37:50 +0000
"Michael J. Rogan" <mrogan@fpelectronics.com>
Re: [HACKERS] sequences
Michael J. Rogan wrote:
> 
> >
> > But we could return PRIMARY KEY of affected tuple if it exists!
> > I kept this feature in mind when thought about removing OID...
> >
> > Comments ?
> 
> This would be very useful.  I never did like the idea of using OID as
> reference so a way to get the PIMARY KEY would be  A GOOD THING(tm).

But we will have to decide how to deal with multi-key PK...

Vadim

Fri, 27 Feb 1998 10:27:07 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] sequences

On Fri, 27 February 1998, at 10:27:07, Vadim B. Mikheev wrote:
> Michael J. Rogan wrote:
> > 
> > >
> > > But we could return PRIMARY KEY of affected tuple if it exists!
> > > I kept this feature in mind when thought about removing OID...
> > >
> > > Comments ?
> > 
> > This would be very useful.  I never did like the idea of using OID as
> > reference so a way to get the PIMARY KEY would be  A GOOD THING(tm).
> 
> But we will have to decide how to deal with multi-key PK...
> 
> Vadim

How is this implemented?

Sun,  1 Mar 1998 13:51:09 -0800 (PST)
Brett McCormick <brett@work.chicken.org>
Re: [HACKERS] sequences
Brett McCormick wrote:
> 
> On Fri, 27 February 1998, at 10:27:07, Vadim B. Mikheev wrote:
> > Michael J. Rogan wrote:
> > >
> > > >
> > > > But we could return PRIMARY KEY of affected tuple if it exists!
> > > > I kept this feature in mind when thought about removing OID...
> > > >
> > > > Comments ?
> > >
> > > This would be very useful.  I never did like the idea of using OID as
> > > reference so a way to get the PIMARY KEY would be  A GOOD THING(tm).
> >
> > But we will have to decide how to deal with multi-key PK...
> >
> > Vadim
> 
> How is this implemented?

Using multi-key unique btree indices. 

Vadim

Mon, 02 Mar 1998 10:31:03 +0700
"Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Re: [HACKERS] sequences