Re: Surrogate Keys: an Implementation Issue

From: Craig Alexander Morrison <>
Date: Thu, 27 Jul 2006 13:53:02 +0100
Message-ID: <44c8b72e_at_212.67.96.135>

> What about compound keys? Compound keys are much more likely to change.
> What if there is more than one candidate key? If the identity changes
> when the key value changes, then what if only one candidate key value
> changes?

> The fact remains that a natural key, however unlikely, can change. If you
> build software around the assumption that it won't, you're going to get
> burned.

If one designs a relational database around the assumption that the PK won't change they are a moron.


Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
"Brian Selzer" <> wrote in message 
snipped all this 'stuff' 
Received on Thu Jul 27 2006 - 14:53:02 CEST

Original text of this message