Subject Re: [firebird-support] Re: Changing domain type into FirebirdSQL
Author Martijn Tonies
> > What error?
> >
>
> Unsuccessful execution caused by system error that does not preclude
> successful execution of subsequent statements.
> action cancelled by trigger (2) to preserve data integrity.
> Cannot update index segment used by an Integrity Constraint.

This means your domain based columns is used by primary key,
foreign key or unique constraints.

You can drop those temporarily, modify your domain and recreate
the constraints.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com