Subject action cancelled by trigger (1) to preserve data integrity
Author sathiesh81
hi All

We have a database created using Firebird beta 2.0 . After installing
Release 2.0.. if we take a gbak and restore the database and try to
edit the datatypes it gives the following error

Error Message:
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
action cancelled by trigger (1) to preserve data integrity.
Cannot update index segment used by an Integrity Constraint.

Workaround is
If we drop the Primary key constraints then it allows to edit without
any error.
The same database tables can be edited in Firebird beta 2.0 without
dropping the constraints.

Can anybody tell me why they did'nt give this in Release 2.0.
Candidate Release 2 & 4?