Subject Firebird restore can not restore index due to duplicate value
Author Hugues Van Landeghem
Hi all,

I have a problem with index when I restore database. I have this message:

>Action cancelled by trigger(3) to preserve data integrity.
>Cannot desactivate index use by a PRIMARY UNIQUE Constraint

When I deactivate Index in restore : it works well.

So I decide to make gfix and I get this
Summary of validay errors :
>Number of record level errors: 6
>Number of index page errors :  9
>When I decide to check the table with problem of primary unique key, I make
SELECT t.table_id FROM TABLE t
GROUP BY table_id
HAVING count(*) > 1

But I find nothing.

How I can see my duplicate value ? (I use Firebird 2.1.3)

Do you now any tools to find quickly where the error come ?

Best Regards