Re: Separate foreign keys with shared ID space

From: Daniel Morgan <>
Date: Sun, 01 Aug 2004 22:38:56 -0700
Message-ID: <1091425170.391131_at_yasure>

Erland Sommarskog wrote:

> Marshall Spight ( writes:

>>"Christian Antognini" <> wrote in message 

> news:410affcf$
>>>A PK should have no business meaning.
>>Says who? Can you justify this statement?

> Because most real-world look-like keys do not live up to the strict
> requirements of the primary keys in a database. They are too often
> nullable or non-unique. Person identification numbers such as SSN
> are a good example of both.

Joe Celko has explained this one to you numerous times and he is correct. Little more needs to be said.

Daniel A. Morgan
University of Washington
(replace 'x' with 'u' to respond)
Received on Mon Aug 02 2004 - 07:38:56 CEST

Original text of this message