Subject Re: action cancelled by trigger (1) to preserve data integrity
Author Adam
--- In, "sathiesh81" <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

You should read the release notes, particularly the part that says not
to post FB 2 beta questions to the Firebird Support list.

> 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.

That exception is raised to prevent you potentially shooting yourself
in the foot. It is possible that someone shot themselves in the foot
between your beta and release candidate you are *** testing firebird
*** with, and that development was done to prevent you suffering the
same fate.