Re: Artificial Primary keys
Date: Mon, 28 Jan 2002 22:57:02 +0100
"Ben Clifford" <benc-news_at_hawaga.org.uk> skrev i en meddelelse
> Jan Emil Larsen wrote:
> > In theory, your "time and place of birth"-key is indeed immutable and
> > I practice, if "time and place" by an error was recorded wrongly, you
> > have to change the key - not because then person became another person,
> > due to an error. Errors happens.
> That's because what you are actually using as the key is *not* the "time
> and place of birth", it is "a person's attempt to record the time and
> place of birth".
> That's a problem, I suppose, for *any* key that has to be input rather
> than generated internally.
The SIZE of the problem is however quite different from one case to another. A SSN is less error prone than "time, longitude, lattitude". In any case: nothing speaks against a surrogate key .... Received on Mon Jan 28 2002 - 22:57:02 CET