Yep - this replicates my problem exactly. I can restore an older backup and
pump in any newer data, but as you say, I would imagine this problem should
be picked up on backup, not restore - to avoid creating an invalid backup.
Is there a validity check I can run on a database which will catch this
prior to backup/restore?

Gabhan O'Loughlin
Development Director
Input Systems
383-384 Clontarf Road
Clontarf
Dublin 3
Ireland

Phone: +353 1 8338100
Fax: +353 1 8338384
EMail: gabhan@...
Web: http://www.input.ie

Get your safe spam protection at http://www.cloudmark.com/spamnetsig/

> -----Original Message-----
> From: David Yanagaki Bonafé [mailto:david.bonafe@...]
> Sent: 12 December 2003 14:40
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] GBAK should validate data during
> backup, not restore
>
> Run that script on a test database:
>
> **********
> create table BUG_TEST
> (
> FIELD1 integer not null
> );
>
> commit;
>
> insert into BUG_TEST (FIELD1) values (1);
> insert into BUG_TEST (FIELD1) values (2);
> insert into BUG_TEST (FIELD1) values (3);
>
> commit;
>
> alter table BUG_TEST
> add FIELD2 integer not null;
>
> commit;
>
> select * from BUG_TEST where FIELD2 is null;
> ***********
>
> then, backup your database with gbak and try to restore it...
>
> ***********
> gbak: ERROR: validation error for column FIELD2, value "***
> null ***"
> gbak: ERROR: warning -- record could not be restored
> gbak: Exiting before completion due to errors
> ***********
>
> IMHO that error should occur during backup, not during
> restore, as a backup that can't be restored isn't a valid backup.
>
> i've been thinking about posting this on sourceforge, but
> don't know exactly if it's a bug or a feature request
>
> PS: sorry if i've made any mistake in spelling or something,
> cause my english isn't perfect :)
>
> _________________________________________________________
> Voce quer um iGMail protegido contra vírus e spams?
> Clique aqui: http://www.igmailseguro.ig.com.br Ofertas
> imperdíveis! Link: http://www.americanas.com.br/ig/
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Buy Ink Cartridges or Refill Kits
> for your HP, Epson, Canon or Lexmark Printer at MyInks.com.
> Free s/h on orders $50 or more to the US & Canada.
> http://www.c1tracking.com/l.asp?cid=5511
> http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>