| From: | Karsten(dot)Hilbert(at)gmx(dot)net |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: surrogate key or not? |
| Date: | 2004-07-23 20:36:23 |
| Message-ID: | 20040723223623.A612@hermes.hilbert.loc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2004-07-24 09:06:35 | Re: surrogate key or not? |
| Previous Message | Josh Berkus | 2004-07-23 17:20:59 | Re: surrogate key or not? |