Re: SERIAL behaviour - Mailing list pgsql-general

From Adrian 'Dagurashibanipal' von Bidder
Subject Re: SERIAL behaviour
Date
Msg-id 1026740848.15188.6.camel@atlas
Whole thread Raw
In response to SERIAL behaviour  (Eugene <foo@bar.com>)
Responses Re: SERIAL behaviour
List 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

Attachment

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: recursing down a tree
Next
From:
Date:
Subject: Re: MySQL vs. PostgreSQL