Subject | Unique PK |
---|---|
Author | Michael Vilhelmsen |
Post date | 2004-02-03T11:35:06Z |
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
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