Hi,
I switched back to Build 156 (Beta1) and to Test1 from December2000. Both
with the same error.

gruse
Carsten

----- Original Message -----
From: "John Bellardo" <bellardo@...>
To: <ib-support@yahoogroups.com>
Sent: Sunday, October 07, 2001 6:39 PM
Subject: Re: [ib-support] Can't insert foreign key constraint


> Hi,
>
> On Sunday, October 7, 2001, at 09:03 AM, Helen Borrie wrote:
>
> > At 04:47 PM 07-10-01 +0200, Carsten Schaefer wrote:
> >
> >>> Carsten,
> >>> Has IBConsole by any chance created case-sensitive identifiers in your
> >> database? Does it work to add the constraint using the same case as
> >> was
> >> used for creating the table, i.e. F_ID_CHARGE.
> >>>
> >>
> >> Helen,
> >> I don't think this is the problem.
> >> (IBConsole shows all Metadata Uppercase)
> >> I tested it with F_ID_CHARGE without another result.
> >> (As i wrote:On another DB with same metadata but with much less data it
> >> works!)
> >
> > Still, volume of metadata shouldn't make a difference.
> >
> > Short of pumping the data into a fresh table, I don't know what to
> > suggest.
>
> A little while ago there were additional constraints added to the
> 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.
>