Greg Stark <[EMAIL PROTECTED]> writes: > I don't see how you're in the clear. If session A does an insert and it > doesn't see a duplicate and doesn't commit, but then B does an insert and sees > the duplicate from A and marks his tentative, and then commits, shouldn't B's > commit succeed?
No. B, being the second to get there, has to wait to see if A commits or not. This is true already and it wouldn't change. We would however postpone the wait until B's commit time. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly