Subject Re: [ib-support] Re: Unsuccessful metatdata update: Index is in use
Author Claudio Valderrama C.
""dietertremel"" <tremel@...> wrote in message
> --- In ib-support@y..., Daniel Rail <daniel@a...> wrote:
> > You're not the only one with that problem. I have the same one.
> And, I
> > can't find the problem either. Out of curiosity, did this work
> properly
> > before FB 1.0? I've only tried it in FB 1.0.
> I tested on the last machine on which I have IB6 (WI-V6.0.0.627).
> There is no problem with the same script.

You should have a very special version of IB6, then, because I tried a
script in exactly the same version than you ( and got exactly the
same error than with FB. The bug happens only if you have CASCADE
declarations. Borland's flawed implementation of cascade RI has three
- this one;
- relies on indices like any IB's RI (makes indices mandatory in FKs);
- database corruption.

The strange INDEX IN USE msg in this specific case has been there since v5,
it wasn't introduced by IB6 nor Firebird.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing