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

Home -> Community -> Usenet -> c.d.o.server -> Re: Indexes and Foreign Keys

Re: Indexes and Foreign Keys

From: Matthias Hoys <anti_at_spam.com>
Date: Sun, 12 Mar 2006 13:56:11 +0100
Message-ID: <44141a6c$0$29466$ba620e4c@news.skynet.be>

>> Please provide functioning SQL example that "changes" a PK value.
>
> Of course they can; however, it points to either an incorrect analysis,
> or some cutting corners when implementing the (correct) design.
> Whether this corner cutting is simply deue to technical constraints
> of the make/model to the DBMS chosen, I cannot answer.
>
> I'd vote for "primary keys should not have a need to be altered".
>

Tell that to the developers :-)

Matthias Received on Sun Mar 12 2006 - 06:56:11 CST

Original text of this message

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