Subject RE: [firebird-support] Unique PK
Author Alan McDonald
> Hi
>
> I wsa wondering what can make a DB (in FB 1.0.3) ignore the unique
> contraint on a PK ?
>
> I have a DB in which there are dub. on a field which is defined as
> Unique PK ?
>
> I have fixed the DB by manully deleting the dub. item !
>
> But the backup that is being done every night can only be restored
> with indexes. Then I would have to delete the dub. records, and
> manually active all indexes again (PK, FK and indexes).
> In this case I could have done that, since the table in question only
> contains some 100 records.
> But next time it could be one of the other tables that contains
> millions of records !
>
> Michael

There was a little hiccup some while back where it was possible to
deactivate the unique index on a PK. Can you check that the db has that
unique index active?
Alan