| Subject | Re: [firebird-support] GBak Backup & Restore Problem |
|---|---|
| Author | Tupy... nambá |
| Post date | 2013-06-25T20:07:07Z |
Mr.Benson,
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@...>
To: firebird-support@yahoogroups.com
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:
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;
commit;
and then perform a new back-up/restore cycle.
see you !
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org/and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
[Non-text portions of this message have been removed]
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@...>
To: firebird-support@yahoogroups.com
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:
>Did the null/not null constraint was applied after the table has some rows ?
> 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
>
>
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;
commit;
and then perform a new back-up/restore cycle.
see you !
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org/and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
[Non-text portions of this message have been removed]