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