"Simon Riggs" <[EMAIL PROTECTED]> writes: > Seems like we should try to locate a row first, then INSERT if we cannot > find one. That's slower on INSERT but more balanced overall
Except it still has the race condition. > I'm a bit surprised the TODO didn't mention the MERGE statement, which > is the SQL:2003 syntax for specifying this as an atomic statement. I believe we concluded that MERGE doesn't actually do quite what people want/expect. Please go back and read the archives. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster