Subject Re: [ib-support] I cannot inactivate foreign index
Author Ann W. Harrison
At 07:24 PM 8/30/2001 +0700, Andy Canfield wrote:
>I am trying to inactivate the index that Firebird automatically provides
>for foreign keys that reference other tables. I get an error saying that I
>cannot deactivate a primary key index. But it isn't a primary key index.

At one point, I thought that only the internal system triggers required
that those indexes exist. Unfortunately, reading a bit more of the code
shows that the existence of foreign key indexes is built-in and will require
considerable work to remove.


We have answers.