Re: FW: Surrogate keys (Was: enums)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: FW: Surrogate keys (Was: enums)
Date: 2006-01-19 03:13:10
Message-ID: 200601181913.11349.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Dann,

> The primary key should be immutable, meaning that its value should not be
> changed during the course of normal operations of the database.

Why? I don't find this statement to be self-evident. Why would we have ON
UPDATE CASCADE if keys didn't change sometimes?

> At any rate, the use of natural keys is a mistake made by people who have
> never had to deal with very large database systems.

Oh, I guess I'm dumb then. The biggest database system I ever had to deal
with was merely 5 TB ...

Anyway, my opinion on this, in detail, will be on the ITToolBox blog. You can
argue with me there.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2006-01-19 03:46:14 \s tail?
Previous Message Bruce Momjian 2006-01-19 03:11:26 Re: [HACKERS] No heap lookups on index

Browse pgsql-hackers by date

  From Date Subject
Next Message uwcssa 2006-01-19 03:35:48 suppress output for benchmarking
Previous Message Bruce Momjian 2006-01-19 03:11:26 Re: [HACKERS] No heap lookups on index