Re: OID's - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: OID's
Date
Msg-id 20041023160923.GB18478@wolff.to
Whole thread Raw
In response to OID's  ("Leen Besselink" <leen@wirehub.nl>)
List pgsql-general
On Sat, Oct 23, 2004 at 14:52:31 +0200,
  Leen Besselink <leen@wirehub.nl> wrote:
>
> id = nextval ("whatever_id_seq");
> insert into whatever (id, text) values (id, 'something');
>
> Something that works always... better, but you need to know the name of
> the sequence, bummer.

In 8.0 (currently in beta) there is a supplied function to return this
string reliably.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: returning inserted rows, derived tables design
Next
From: Oliver Elphick
Date:
Subject: Re: Slony-I 1.0.4 Released