Subject | Re: [firebird-support] Re: Foreign key constraint violation |
---|---|
Author | Ann W. Harrison |
Post date | 2008-02-28T16:37:47Z |
hfsnell wrote:
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
>> I'm hoping one of the experts will join in, but in the meantime I haveThat's a check that has to be made very carefully. It's possible for
>> 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.
>
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