[snip] > We hope to have shared row locks in 8.1 for this usage. This feature is one I'm really waiting for ! Is there any estimate when 8.1 comes out ? I know, I know, the preferred answer is "whenever it's ready", but if 8.1 is not that far away, and shared row locking will be in it, I won't bother patching 8.0 to skip FK parent row locking altogether (which is not the most orthodox way to avoid the FK related deadlocks)...
Thanks to all the developers, Csaba. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
