Subject Re: [firebird-support] GBak Backup & Restore Problem
Author Tupy... nambá
No, the constraint wasn´t change. As I explain to mr.Jesus Garcia, we take the DB having the data and the constraint in the needed conditions, we made a backup and then the restore. This mean = all the conditions were assured that the DB were in "good conditions" and, during the backup/restore process, the data at this column was "lost".
Thank you, i.c.u.2 !
Roberto Camargo

From: Alexandre Benson Smith <iblist@...>
Sent: Tuesday, June 25, 2013 4:33 PM
Subject: Re: [firebird-support] GBak Backup & Restore Problem

Em 25/6/2013 16:23, Tupy... nambá escreveu:
> Dear Friends,
> We have a strange problem with GBak. We make a backup with gbak and then a restore, also with the same.
> We have a table with 60 rows where a not null type SmallInt column has 0 (zero) as content.
> When restoring, GBak returns null for this column. As this column is not null, we get an error message (Error: Validation error for column .....).
> Between these two steps (backup and restore), no further action is done with the backup file.
> I ask you = What can cause this problem? Is there any solution for this? Any idea about this problem?

> Thanks a lot,
> Roberto Camargo,
> Rio de Janeiro / Brasil

Did the null/not null constraint was applied after the table has some rows ?

IIRC there is something regarding NULL stored and the column be changed
to NOT NULL with a DEFAULT, and so FB will return the DEFAULT value to
NOT NULL columns that in fact is NULL.

I suggest you to do:
update MyTable set MyColumn = 0 where MyColumn is null or MyColumn = 0;

and then perform a new back-up/restore cycle.

see you !



Visit click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links

[Non-text portions of this message have been removed]