Subject Re: [firebird-support] Re: Database compress/purge
Author Helen Borrie
At 01:28 AM 24/07/2003 -0700, Scott Taylor wrote:

>Paul Schmidt said:
> > First time you restore, when it finds a NULL it will explode faster
> > then a Ford Pinto rear-ended by a Mack sized truck.

Scott Taylor wrote:

>Not so, everything else is restored, only the records that have errors
>will not restore as would be with any RDBMS. Nothing has blown up,
>the RDBMS has done exactly as you asked it: do not allow records in
>this table that have field X as null.

Uh-huh - so you've tried this, have you?

> > 99% of the time a restore fails this is the reason why.
>Therefore 99% of DB failures are do to user stupidity? That I can

No, developer stupidity. It's really very hard for users - even stupid
ones - to corrupt a database. It's axiomatic that a DBMS will find and
punish stupid developers.