Subject RE: [firebird-support] DUP key on restore
Author Svein Erling Tysvær
>Hi Tomasz. I already checked the source database for duplicated entries,
>and found none, but i did not tried to verify the database with gfix.

Exactly how did you check it for duplicate entries? The point is that if there's a problem with an index or key, then doing

SELECT MyIndexedField, count(*)
FROM MyTable
GROUP BY 1
HAVING count(*) > 1

will use the index/key and not discover the duplicate entry, whereas

SELECT MyIndexedField+0, count(*)
FROM MyTable
GROUP BY 1
HAVING count(*) > 1

cannot use the index and will find such duplicates.

HTH,
Set