Re: delete cascade
From: David Cressey <cressey73_at_verizon.net>
Date: Wed, 18 Apr 2007 16:38:36 GMT
Message-ID: <gQrVh.19078$Yh.11910_at_trndny03>
Date: Wed, 18 Apr 2007 16:38:36 GMT
Message-ID: <gQrVh.19078$Yh.11910_at_trndny03>
"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message
news:FepVh.25684$PV3.261993_at_ursa-nb00s0.nbnet.nb.ca...
> The normal effect of a constraint is simply to block any inconsistent
> update. You gave an english phrase suggesting all foreign keys should
> cascade deletes, and I gave a similar english phrase suggesting they
> should not. Both are useful.
I'm taking "inconsistent update" to mean "an update that would leave the
database in an inconsistent state".
Is my reading correct? And, if so, do the two phrases mean the same thing?
Received on Wed Apr 18 2007 - 18:38:36 CEST