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.
