On Sep 5, 2005, at 3:01 AM, Jan Danielsson wrote:
> 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.
Welcome to PostgreSQL!
This is a very common misconception. Your fears are unfounded.
Read the FAQ or the documentation for details.
http://www.postgresql.org/docs/faqs.FAQ.html#4.11.1
http://www.postgresql.org/docs/8.0/interactive/functions-sequence.html
Hope this helps.
Michael Glaesemann
grzm myrealbox com