> the table in question seems to have duplicates in the primary key
> column.
>
> Has anyone ever seen this before, or do they know of how it could occur?

Yes, the database does not have set Force Write flag.

Ivan

----- Original Message -----
From: "Ryan Thomas" <ryan@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, July 12, 2005 12:48 AM
Subject: [firebird-support] Duplicate Primary Keys


> Hi all,
>
> I came across this database this morning. It belongs to a client of ours who
> was reporting some errors when using our software. On inspection of the
> database the table in question seems to have duplicates in the primary key
> column.
>
> Has anyone ever seen this before, or do they know of how it could occur? The
> table does not have any foreign keys and the database is generally only
> accessed by the one connection.
>
> I have made a copy of the database available, however all of the triggers /
> stored procedures / views and non-related tables have been removed. The only
> table in the database is titled MBUSERCOMPANY, if you look at the row where
> COMPANYNAME is 'Seaside Home Loans' you will see that there are two entries
> both with the same key.
>
> The database zipped down to ~3Mb, I tried doing a backup/restore on it but
> the restore failed with an integrity check error (the duplicate PK).
>
> Here's the database:
> http://www.transactive.com.au/dup_pk.zip
>
> Any insight into this would be great.
>
> Cheers,
>
> Ryan Thomas
> TransActive Systems
>
> P: (02) 4322 3302
> F: (02) 4325 1141
> E: ryan@...
> W: http://www.transactive.com.au/