Subject Re: [ib-support] Restore validity problems.
Author Ann W. Harrison
At 11:29 AM 12/31/2001 +0100, Alessandro Ortuso wrote:
>I use Firebird Beta2 on Windows 2000 Server.
>The database is 600 Mbytes.
>I added a new field in an existing table with a NOT NULL constraints.
>When I try to restore the db I have an error of validation of the field
>TYPE_PRODUCT (previously created). I tried to set the restore parameter
>"Validity conditions" to FALSE but the error appears too.
>Some idea?

Yes, that's a common and annoying problem. InterBase (and Firebird by
inheritance) doesn't check validity conditions when they're added. Depending
on how comfortable you are with the idea, you could build a debugging
gbak, disable the NOT NULL constraint, and complete the restore. Or
you could hire someone to do that for you. I can certainly do it (not
free) and so could a lot of the firebird developers.


We have answers.