Subject GBAK - validation error for column X, value "*** null ***"
Author Josef KokeŇ°
Hi!

What would be a proper way of dealing with GBAK restore error
'validation error for column X, value "*** null ***"'? This error
appears in one table, where X is the primary key. The database is
Firebird 2.5.4 in the superserver mode.

1) How do I properly restore this backup? Neither -INACTIVE nor
-NO_VALIDITY (nor both at the same time) help, the restore stops as soon
as the first error is encountered. -ONE_AT_A_TIME gets me to the end of
table data, but then I get another error at the "restoring privilege for
user Y" "action cancelled by trigger (3) to preserve data integrity"
"table/procedure has non-SQL security class defined".

2) Why doesn't GBAK complain during backup? I would expect that if a
backup is successfully made, I will be able to restore it.

Thanks,

Josef