On Fri, 25 Nov 2005, Wes wrote:
> I haven't seen anything to indicate that 8.x improves foreign key
> refererence locking and fixes the foreign key 'deadlock detected' issue.
> Has that been addressed in 8.1?
8.1 should be using the new shared row locks for doing the checks. This
should fix the case mentioned.
> I've never quite understood why a READ of a record with a foreign key
> reference results in the referenced record being locked with more than a
> shared lock.
Up until now, we didn't have one to get on a per-record basis.