Re: Newbie question

From: Alfredo Novoa <>
Date: Tue, 21 Jun 2005 13:06:16 +0200
Message-ID: <>

On Tue, 21 Jun 2005 10:39:12 +0200, Jon Heggland <> wrote:

>> Why is this an advantage?
>Cheap answer: Because Oracle doesn't support ON UPDATE CASCADE. :)

It is cheap, indeed :)

>> Most natural keys are never unknown.
>It's hard to disagree with qualified statements like that, but as long
>as some natural keys may be unknown or inapplicable or whatever,
>surrogate keys have a use.


>> >Anyway, many "real-world" keys are really surrogates---SSNs, account
>> >numbers, registration numbers, student numbers and so on.
>> And that is a reason for not creating new surrogates.
>I'm not saying you should exclusively use surrogates and never natural

I am not saying the contrary. I think that we should not create surrogate keys whether we have good natural keys.

> My point was simply "primary key != natural key"---

Trivially true :)

Regards Received on Tue Jun 21 2005 - 13:06:16 CEST

Original text of this message