Re: Surrogate Keys: an Implementation Issue
From: Roy Hann <specially_at_processed.almost.meat>
Date: Thu, 20 Jul 2006 09:10:38 +0100
Message-ID: <58SdnQYPPrMOpyLZRVny3g_at_pipex.net>
Date: Thu, 20 Jul 2006 09:10:38 +0100
Message-ID: <58SdnQYPPrMOpyLZRVny3g_at_pipex.net>
"Damien" <Damien_The_Unbeliever_at_hotmail.com> wrote in message
news:1153366546.518700.117220_at_s13g2000cwa.googlegroups.com...
> Just a quick question. What if, for whatever reason, you did NOT want
> "ON UPDATE CASCADE" semantics? It seems you cannot avoid them in your
> situation...
Before exerting myself to think of an answer to this, why, after assering that an attribute is a foreign key, would it ever be reasonable not to want ON UPDATE CASCADE? If the attribute is not a foreign key, don't say it is.
Roy Received on Thu Jul 20 2006 - 10:10:38 CEST