Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Surrogate Keys: an Implementation Issue

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@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 - 03:10:38 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US