Hi,
I wrote SP for testing. There's a select with specified plan in it:
PLAN (MASTER INDEX (MASTER_PTYPE, RDB$FOREIGN30))

I droped FK RDB$FOREIGN30 in table MASTER, but forgot to modify
PLAN before. Now I can't modify or drop this procedure. I always get:

"This operation is not defined for system tables.
unsuccessful metadata update.
ERASE RDB$PROCEDURE_PARAMETERS failed.
invalid request BLR at offset 1045.
there is no index RDB$FOREIGN30 for table MASTER."

or when dropping

"Invalid token.
invalid request BLR at offset 1045.
there is no index RDB$FOREIGN30 for table MASTER."

Is it possible (and safe) to drop it directly in RDB$PROCEDURES? Or
how can I drop it now? Recreating of FK is unsuccessful.
Thanks if anyone could advise me.

--
Martin (mailto:moirae@...)