Re: Surrogate keys (Was: enums) - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Surrogate keys (Was: enums)
Date
Msg-id 200601181558.50878.josh@agliodbs.com
Whole thread Raw
In response to Re: Surrogate keys (Was: enums)  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Surrogate keys (Was: enums)  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Martjin,

> Interesting. However, in my experience very few things have "natural
> keys". There are no combination of attributes for people, phone calls
> or even real events that make useful natural keys.

I certainly hope that I never have to pick up one of your projects.   A 
table without a natural key is a data management disaster.   Without a 
key, it's not data, it's garbage.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: No heap lookups on index
Next
From: "Dann Corbit"
Date:
Subject: Re: Surrogate keys (Was: enums)