> At 07:58 AM 5/8/2004, Geoff Worboys wrote:
> > >>If corruption occurs due to bugs, the bugs need to be fixed.
> >...
> > > Quite. And does this also include "logical" corruption, that
> > > is, when the database gets into some inconsistant state at a
> > > high level? It seems that there are a few known issues of
> > > this sort. Are they to be considered as simply bugs?
>
> Well, they're certainly not features. There is some disagreement
> in my family about adding constraints to a populated database. I
> think the system should check that the constraint is consistent
> with the state of the database before the constraint is added. My
> beloved thinks that's unreasonable - slow etc.

FWIW, I agree with Ann here.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com