| Subject | Re: duplicates in a table with PK |
|---|---|
| Author | Adam |
| Post date | 2007-05-31T23:31:54Z |
--- In firebird-support@yahoogroups.com, "Puigsegur, Jordi"
<jordi.puigsegur@...> wrote:
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.
Adam
<jordi.puigsegur@...> wrote:
>That should never happen unless you have corruption in the index
> We have a very strange situation with a FireBird database: a table with
> a PrimaryKey has duplicate values.
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.
Adam