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.

-John