| Subject | Re: [ib-support] Can't insert foreign key constraint |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-10-08T02:48:40Z |
At 10:03 PM 07-10-01 +0200, you wrote:
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.
rgds,
Helen
>Hi,Carsten,
>I switched back to Build 156 (Beta1) and to Test1 from December2000. Both
>with the same error.
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.
rgds,
Helen