Re: SERIAL behaviour

you can use currval() to get the current value of a sequence.

however if your key value is set to serial and it's default is the nextval
then don't reference it in your insert i.e.

insert into foo(forename,surname) values ('Steve','Brett');

where the key for foo is an id of type serial.

currval() 'should' be safe for use within transactions.

Steve

> -----Original Message-----
> From: Adrian 'Dagurashibanipal' von Bidder
> [mailto:avbidder(at)fortytwo(dot)ch]
> Sent: 15 July 2002 14:47
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] SERIAL behaviour
>
>
> On Sun, 2002-07-14 at 03:59, Eugene wrote:
> [ SERIAL type / SEQUENCEs and transactions ]
>
> Closely related: what's the official/preferred way if I'm
> inserting rows
> into a table with a auto assigned id (SERIAL), to get the
> newly created
> id? asking the sequence obviously will not work - as the sequence will
> advance when the next value is inserted from another transaction.
>
> cheers
> -- vbi
>
> --
> secure email with gpg http://fortytwo.ch/gpg
>