Re: [JDBC] Retrieving last InsertedID : INSERT... RETURNING safe ?

Dave Cramer wrote:
>> Well, that other solution is dangerous in case multiple inserts
>> to that table are done concurrently; a quite common usage pattern
>> with java web applications handling multiple HTTP requests with
>> concurrent java threads..
>>

> No it is not dangerous. It is the right way to do it. There is > absolutely no danger in using currval in this manner.

Unless you have autocommit on.

-- 
Paul Tomblin <
ptomblin(at)xcski.com> 
http://blog.xcski.com/
"Only a NAZI would try to invoke Godwin's [law] deliberately"
     - Jeff Gostin in a.s.r

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                
http://www.postgresql.org/about/donate