Re: surrogate key or not? - Mailing list pgsql-sql

From Karsten.Hilbert@gmx.net
Subject Re: surrogate key or not?
Date
Msg-id 20040723223623.A612@hermes.hilbert.loc
Whole thread Raw
In response to Re: surrogate key or not?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Josh,

> > In other words, with surrogate keys, you eliminate the chance
> > that your original design was flawed due to lack of important
> > initial knowledge.
> 
> Well, you don't *eliminate* it, but you do decrease it.   
> 
> I'd say, yes, this is an important 4th reason:   
> 
> 4) Your spec may be incorrect and surrogate keys make it easier to make design 
> changes in production.

thanks so much - this is exactly the kind of assurance I was
looking for.

BTW, I will come back to your generous offer in August.
Thanks again.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: surrogate key or not?
Next
From: Karsten Hilbert
Date:
Subject: Re: surrogate key or not?