Re: Last value inserted - Mailing list pgsql-general

From Richard Huxton
Subject Re: Last value inserted
Date
Msg-id 4193B30B.40905@archonet.com
Whole thread Raw
In response to Last value inserted  (MaRCeLO PeReiRA <gandalf_mp@yahoo.com.br>)
List pgsql-general
MaRCeLO PeReiRA wrote:

> How can I now (for sure) with value was generated by
> the sequence to fill the field ID?
>
> (There is lots of users using the software at the same
> time, so I am not able to use the last_value()
> function on the sequence.)

Yes you are nextval()/currval() are multi-user safe. They return the
next/current value *in the current connection*.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: OID Question
Next
From: Robert Fitzpatrick
Date:
Subject: DROP DATABASE, but still there