Subject Re: [firebird-support] Re: Foreign key constraint violation
Author Ann W. Harrison
hfsnell wrote:

>> I'm hoping one of the experts will join in, but in the meantime I have
>> one question for you: Is FK_OBJECT_BAL_1 always present/active? Or
> is it
>> perhaps temporarily removed at certain operations?
> When I import data from outside (such as xls file) this contraint is
> inactive. But I always check after importing, the db is at good status.
>

That's a check that has to be made very carefully. It's possible for
the database to appear to be consistent when it's actually not because
the transaction making the check doesn't see concurrent changes.


Regards,

Ann