| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |