Re: SERIAL behaviour

From: Adrian 'Dagurashibanipal' von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SERIAL behaviour
Date: 2002-07-15 13:47:28
Message-ID: 1026740848.15188.6.camel@atlas
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George.T.Essig 2002-07-15 13:47:37 Re: MySQL vs. PostgreSQL
Previous Message Oleg Bartunov 2002-07-15 13:39:08 Re: recursing down a tree