Hi, We use Firebird 2.5.1 on Linux 64 bit
Firebird fails to restore because of a unique constraint( see below ). However when interrogating the data, no duplicate is found. ( see below SQL, unique key is on the grouped by fields ) How can this be? Kind Regards, Robert. SELECT ID_VN, CD_ITM_SPR FROM AS_ITM_SPR GROUP BY ID_VN, CD_ITM_SPR HAVING COUNT(*) > 1 gbak: activating and creating deferred index AK_AS_ITM_SPR gbak:cannot commit index AK_AS_ITM_SPR gbak: ERROR:attempt to store duplicate value (visible to active transactions) in unique index "AK_AS_ITM_SPR" gbak: ERROR:action cancelled by trigger (3) to preserve data integrity gbak: ERROR: Cannot deactivate index used by a PRIMARY/UNIQUE constraint gbak:Exiting before completion due to errors
