Subject Re: [Firebird-Architect] Backup
Author Ann W. Harrison
Alexandre Benson Smith wrote:
>
> Anyway was my fault to not adjust my data to the new
> rule, but will be good if the engine help me not to forgot about it.
>

That's an on-going discussion - decades long now. The original decision
at InterBase was that careful programmers test their data before adding
constraints, so having the system test it penalized the careful in order
to protect others from the reasonable consequences of their errors. In
some cases - unique constraints being one - building the structure
necessary to enforce the constraint automatically checks.

In any event, gbak needs to be able to restore data without constraints
to somebody who runs into an actual bug in the database software doesn't
suffer irreversible data loss.

Regards,


Ann