In the course of chasing down a bug, I realized that a number
of indexes in the system tables which should be unique are not.
I've changed that. The indexes affected are

index RDB$INDEX_1 for RDB$RELATIONS on RDB$RELATION_ID

index RDB$INDEX_14 for RDB$CHECK_CONSTRAINTS on RDB$CONSTRAINT_NAME

compound index RDB$INDEX_16 for RDB$FORMATS on RDB$RELATION_ID and
RDB$FORMAT

index RDB$INDEX_22 for RDB$PROCEDURES on RDB$PROCEDURE_ID

index RDB$INDEX_24 for RDB$EXCEPTIONS on RDB$EXCEPTION_NUMBER

index RDB$INDEX_36 for RDB$FIELD_DIMENSIONS on RDB$FIELD_NAME

You might just check that your databases generally follow those
rules.


Regards,

Ann
www.ibphoenix.com
We have answers.