Re: [GENERAL] Duplicate key insert question

[Jean-Christian Imbeault]

Reuben D. Budiardja wrote:
> 
> No, onlu *one* of them will fail, but yes, the other will then generate error. 
> So it really is a trade off. Another way would be to lock the table, as other 
> has suggested. But then there is disadvantages to that also.

Really? I just got a post form Alvaro Herrera saying;

"The solution is not correct in that there _is_ a race condition."

Maybe I misunderstood, but "not correct" doesn't sound good :)

Jean-Christian Imbeault


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])