Re: Delete of child-entry locks father-table

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 3 Dec 2006 07:28:08 -0800
Message-ID: <1165159688.515453.298520@73g2000cwn.googlegroups.com>

HerbertMueller3_at_gmx.at wrote:
> If I delete data from a child-table, then the father tables get locked.
> I can not understand the reason for locking the father-table when
> deleting child-entries.
>
> Can someone explane that to me???

>
> If the deletion job and the "make valid task" run at the same time than
> one task do not work, because the config-table is locked.

It could be a problem with un-indexed foreign keys. A Google search may help:
unindexed foreign keys kyte

Some of the results returned by the above: http://www.jlcomp.demon.co.uk/faq/fk_ind.html http://tkyte.blogspot.com/2006/11/interesting-post.html

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Sun Dec 03 2006 - 09:28:08 CST