Subject Re: [ib-support] Can't insert foreign key constraint
Author Carsten Schäfer
the table t_ch_apos_zuord is the normal n-m Relationship between the
tables t_charge and t_apos.
There is no other direct relationship between t_charge and t_apos.
BTW how to delete the primary key from a table ?


----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <>
Sent: Monday, October 08, 2001 4:48 AM
Subject: Re: [ib-support] Can't insert foreign key constraint

> At 10:03 PM 07-10-01 +0200, you wrote:
> >Hi,
> >I switched back to Build 156 (Beta1) and to Test1 from
December2000. Both
> >with the same error.
> Carsten,
> Some more thoughts...
> Is it possible that one of the columns in the primary key of the
child table has a dependency that links it circularly to the
referenced table?
> If it is essential to have both of these columns to get a unique
row, why not use a surrogate primary key and place a UNIQUE constraint
over these two columns? This should free whatever dependency is
preventing the formation of the foreign key relationship.