Subject Re: duplicates in a table with PK
Author Adam
--- In, "Puigsegur, Jordi"
<jordi.puigsegur@...> wrote:
> We have a very strange situation with a FireBird database: a table with
> a PrimaryKey has duplicate values.

That should never happen unless you have corruption in the index
supporting the primary key constraint (which should never happen with
forced (synchronised) writes enabled).

I can't offer any more hints as to how it happenned, but you will need
to repair it manually. You can use RDB$DB_KEY to distinguish between
the records during the repair.