On 5/3/12 9:06 PM, Vineet Deodhar wrote: > Isn't it dangerous to get a pkid from the db before commit? > Consider a situation where UserA gets a pkid "2564' for a table "tbl1". > Before this change is committed, UserB inserts a record to tbl1& gets > "2564". > > Wouldn't is cause a mess?
No, postgres knows it handed out 2564 already, even though it isn't committed yet. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
