You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Let's have a database with a table:
create table test (id integer);
and data:
insert into test (id) values (1);
Later, we can alter table with something like:
alter table test add name varchar (100) not null;
Succeeded, but table contains (or, can contain) "invalid" data - in our case column is added, and for existing data values in "name" column are set to NULL (!)
And now problem: If I try to RESTORE from that backup, it FAILED:
gbak -c -v -REP -user SYSDBA -password masterkey <path to backup> localhost:<database>
gbak:restoring data for table TEST
gbak: ERROR:validation error for column NAME, value "*** null ***"
gbak: ERROR: warning -- record could not be restored
gbak:Exiting before completion due to errors
I thing it's too bad - GBAK allows me to BACKUP, but restore in this case is not possible ;-(
The text was updated successfully, but these errors were encountered:
Submitted by: Petr Zajic (xzajic)
Duplicates CORE1748
Let's have a database with a table:
create table test (id integer);
and data:
insert into test (id) values (1);
Later, we can alter table with something like:
alter table test add name varchar (100) not null;
Succeeded, but table contains (or, can contain) "invalid" data - in our case column is added, and for existing data values in "name" column are set to NULL (!)
Never mind; let's backup:
gbak -v -t -user SYSDBA -password "masterkey" localhost:<database> <target>
Succeeded.
And now problem: If I try to RESTORE from that backup, it FAILED:
gbak -c -v -REP -user SYSDBA -password masterkey <path to backup> localhost:<database>
gbak:restoring data for table TEST
gbak: ERROR:validation error for column NAME, value "*** null ***"
gbak: ERROR: warning -- record could not be restored
gbak:Exiting before completion due to errors
I thing it's too bad - GBAK allows me to BACKUP, but restore in this case is not possible ;-(
The text was updated successfully, but these errors were encountered: