Postgres Pro
Downloads
Home   >   mailing lists

Re: pervasiveness of surrogate (also called synthetic) keys - Mailing list pgsql-general

From Scott Ribe
Subject Re: pervasiveness of surrogate (also called synthetic) keys
Date
Msg-id D8550886-DE74-4D06-B7E5-5ED0B9C4FC57@elevated-dev.com
Whole thread Raw
In response to Re: pervasiveness of surrogate (also called synthetic) keys  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: pervasiveness of surrogate (also called synthetic) keys
List pgsql-general
Tree view 
On Apr 28, 2011, at 11:53 AM, Rob Sargent wrote:

> Hm, I get the feeling that only the good folks at Hibernate seem to think using a "natural key" is the _only_ way to
go.

Well, natural keys are quite obviously the way to go, when they exist. The problem is, they usually don't really exist.
What'susually proposed as a natural key, will upon further investigation, either not be guaranteed unique, or not
guaranteedto be unchanging, or both. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Next
From: Daniele Varrazzo
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys