Re: Experiencing problem with "post" packaged Pro.

From: Dave Mausner <dlm_at_dlogics.dlogics.com>
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

Original text of this message