Subject RE: [firebird-support] Re: Gbak and checks
Author Leyne, Sean

> I dont fully agree with you.

Too bad the SQL committee doesn't agree with you.

*You* are responsible for ensuring that existing data is updated to meet
any new constraints that you add.

> If the process can be improved, why dont do?
> I've set my new field as "not null default = 0".

"Default" only applies to records which are INSERTed. Not to existing

> I dont know how other DB engines resolves that problems, but I'm prety
> sure that dont do what gbak does (At least SQL Server doesnt).

There is a gbak option which allows for restores without enforcing
constraints. Have you tried this?