Hi Helen,

For dropping the foreign key constraint I just used a script with
alter table drop fkconstraintxxx. I write this because IBAdmin was
mentioned as a possible cause, but I did not used to execute script.
Instead I used the latest version of IBConsole, which I like more
executing larger scripts.

I still have to try to reproduce this problem, because I can not
stand not knowing what went wrong.

With kind regards,

Olivier Olmer
Oxolutions



--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 11:48 AM 19/06/2003 +0000, you wrote:
> >Hi Helen,
> >
> >You are right! Thank you The indexes are disabled. Actually all the
> >indexes of all tables are inactive. Since I know for sure we did

not

> >alter indexes to deactivate them. Simply we did not know this

feature.

> >
> >I like to know what else could cause this to happen.
> >
> >The only thing we have done is dropping foreign key constraints to
> >speed up the delete of about 4.000.0000 records.
>
> I haven't used IBAdmin, but maybe it does a global set inactive on

all

> indexes when it gets a request to drop FK constraints. Weird if it
> does. Or maybe you checked a checkbox that you didn't mean to.
>
> Otherwise gremlins. Definitely. They have a known reputation for

getting

> into servers at night and doing REALLY sneaky things.
>
> heLen