Re: Table Locking

On Thu, 02 Dec 2004 14:03:10 +0000, Joseph Dimech wrote:

>
> My question is: what could be causing processes to attain LOCK MODES 4 and 5
> when there is noting explicitly in my code to do so?

Foreign keys columns not having indexes. An update of the parent table will lock the whole child table in the shared mode to prevent inconsistencies.

-- 
Artificial Intelligence is no match for natural stupidity.