|Subject||Re: [ib-support] Can't insert foreign key constraint|
|Author||Ann W. Harrison|
>On Sunday, October 7, 2001, at 09:03 AM, Helen Borrie wrote:At 09:39 AM 10/7/2001 -0700, John Bellardo wrote:
> >>> Has IBConsole by any chance created case-sensitive identifiers in your
> >> database? ...
> > At 04:47 PM 07-10-01 +0200, Carsten Schaefer wrote:
> >> As i wrote:On another DB with same metadata but with much less data it
> >> works!
>A little while ago there were additional constraints added to theI agree with John that the problem is likely to be in constraints,
>metadata in Firebird. Could it be possible the trigger is stopping an
>insert into the RDB$REF_CONSTRAINTS table? You could try an older build
>of Firebird to see if it works. I think the additional metadata
>constraints were not in beta 1.
but think that it is a long standing problem that surfaces from time
to time when the parent table has both a primary key and an unique
index. Something way deep in the constraints fails and the failure
cascades, resulting in the "constraint not defined" message.
We have answers.