Subject Re: [ib-support] Re: Unsuccessful metatdata update: Index is in use
Author Claudio Valderrama C.
""dietertremel"" <tremel@...> wrote in message
news:a7emd8+ae23@......
> --- In ib-support@y..., Daniel Rail <daniel@a...> wrote:
>
>
> has anybody of the FB Cracks read this thread? Any Opinions and
> Comments?
> From my point of view it is rather severe that FB doesn't work with
> DDL that IB handles well.

Nothing to say. I've tested all IBs up to IB6.02 and all have the same
problem, so your statement is plain wrong. Dropping simple FKs, no problem.
Dropping two FKs on the same table and both FKs having CASCADE operations
cause the problem in any IB/FB. I've shown the workaround, too.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing