hi all,

I have a domain declared as NUMERIC(9,0), used in many tables already
populated. I want to change the type of the domain to BIGINT, but the
"ALTER DOMAIN" command failed with the error message :
"Statement failed, SQLCODE = -607

unsuccessful metadata update
-MODIFY RDB$FIELDS failed
-action cancelled by trigger (1) to preserve data integrity
-Cannot update index segment used by an Integrity Constraint"

I tried NUMERIC(18,0) instead of BIGINT, thinking it was an invalid
conversion, but it gave me the same error.

What's wrong ? And how can I do this modification ?

Thanks in advance.

B.L.