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


Any ideas?


Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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