Re: Experiencing problem with "post" packaged Pro.
Date: Tue, 24 Aug 1993 11:57:23
Message-ID: <930824115723_at_dlpc030.dlogics.com>
In article <10155_at_bwc.BWC.ORG> farzin_at_bwcbwc.org (Farzin Shakibanejad) writes:
> I have encountered a problem which has to do with table locking and is
> explained by the following example.
> [deleted to reduce net traffic]
The problem you described occurs when you have a foreign-key constraint in a child table, and the foreign key is not indexed. When you add a row to the child table, the parent table acquires a share lock which prevents inserts or updates until the transaction is committed. This is a feature, not a bug, but I will not argue in favor of it.
For further information, refer to _Oracle7 Application Developer's Guide_, part number 6695-70-1292, pages 6-8 thru 6-11.
You can solve the problem by adding an otherwise-pointless index on the child table, containing only the foreign key of the parent.
-- Dave Mausner / Sr Consultant / Datalogics division of Frame Technology Inc 441 W Huron / Chicago IL 60610 / +1-312-266-4450 / "Just show me the code"Received on Tue Aug 24 1993 - 11:57:23 CEST