Subject Firebird and deactivating FK indices
Hi all,

the Firebird RC1 release notes state that I should be able to de-
activate FK indices...

But, I get this message on trying:

"unsuccessful metadata update MODIFY RDB$INDICESS failed action
cancelled by trigger (3) to preserve data integrity Cannot deactivate
primary index"

The statement I tried was:

alter index RDB$FOREIGN3 inactive

Where, of course, RDB$FOREIGN3 is the index of the FK defined for the

Any ideas?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."