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

From Andres Freund
Subject Re: pervasiveness of surrogate (also called synthetic) keys
Date
Msg-id 201105021150.23281.andres@anarazel.de
Whole thread Raw
In response to Re: pervasiveness of surrogate (also called synthetic) keys  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-general
On Thursday, April 28, 2011 08:31:09 PM Scott Ribe wrote:
> 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.
There is no fundamental problem with changing primary keys. Sure, there are
challenges and situations where thats annoying and problematic, but it's not
as bad as often assumed.

Andres

pgsql-general by date:

Previous
From: Marek Więckowski
Date:
Subject: auto-reconnect: temp schemas, sequences, transactions
Next
From: sm
Date:
Subject: wnat ot edit pg_hba.conf file from command prompt