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.

With kind regards,

Olivier Olmer
Oxolutions





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

> At 09:01 AM 19/06/2003 +0000, you wrote:
> >We experienced succesful inserts in the database while it is
> >violating the primary key constraint.
> >This appeared using firebird 1.02 with multiple files. Even after
> >backup restore this still is the case.
> >
> >This problem does not appear till we dropped some foreign key
> >constraints by its name.
> >
> >Two questions:
> >How do I solve the problem of deleting the double records (since

they

> >are exactly the same?
>
> See Alan's post.
>
> >Which version of firebird is reliable on testing the primary key
> >constraint.
>
> All. I've only ever seen this occur where the programmer had taken

advice

> to set indexes inactive while doing bulk inserts, so he took it

literally

> and disabled them all, including the unique index that system

created to

> enforce the PK!!
>
> heLen