Jan Danielsson <jan(dot)danielsson(at)gmail(dot)com> writes:
> I have seen a few "currval", "last_value", tricks and such, but they
> aren't good enough, AFAICT, since they only work when I can guarantee
> that no one else will insert a new record between the time that I insert
> one, and query for the last_value.
You evidently do not understand how currval works. It is session-local,
so the race condition you are imagining does not exist.
regards, tom lane
In response to
- Last Id? at 2005-09-04 18:01:47 from Jan Danielsson
pgsql-novice by date
|Next:||From: Michael Glaesemann||Date: 2005-09-06 03:56:00|
|Subject: Re: Last Id?|
|Previous:||From: Tom Lane||Date: 2005-09-06 01:05:50|
|Subject: Re: PGSQL and Nested Loops |