Josh Berkus <[EMAIL PROTECTED]> writes:
>> Hey at least I noticed that InnoDB has one essential feature we don't:
>> Which does a shared lock on a row as opposed to a write lock, hence 
>> avoiding nasty foreign key deadlocks...

> Um, wrong.   We don't lock rows for SELECT.

No, but Chris is correct that we could do with having some kind of
shared lock facility at the row level.

                        regards, tom lane

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

Reply via email to