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's usually proposed as a natural key, will upon further investigation, either not be guaranteed unique, or not guaranteed to be unchanging, or both.

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

In response to

• Re: pervasiveness of surrogate (also called synthetic) keys at 2011-04-28 17:53:02 from Rob Sargent

Responses

• Re: pervasiveness of surrogate (also called synthetic) keys at 2011-05-02 09:50:22 from Andres Freund

pgsql-general by date

Next:	From: Daniele Varrazzo	Date: 2011-04-28 19:03:43
	Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Previous:	From: Joshua D. Drake	Date: 2011-04-28 18:26:50
	Subject: Re: pervasiveness of surrogate (also called synthetic) keys