| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
| Cc: | "Postgresql (General)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pervasiveness of surrogate (also called synthetic) keys |
| Date: | 2011-05-03 05:18:22 |
| Message-ID: | C569B12E-23B2-4DFF-868F-5AC2658D1460@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On May 2, 2011, at 10:53 PM, Rob Sargent wrote:
> ...and you're at risk of having to reformat them when you buy out your competitor.
The scheme described was awfully similar to one that a client of mine used, product family prefix, identifiers within the family. And guess what? The scheme, which had been stable for 20+ years, had to change when a new variant of product was introduced which cut across family & product. I don't remember the details. I do remember that I hadn't used the supposedly stable product ids as PKs ;-)
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-05-03 05:39:46 | Re: Seg Fault in backend after beginning to use xpath (PG 9.0, FreeBSD 8.1) |
| Previous Message | Tom Lane | 2011-05-03 05:14:54 | Re: Help with database recovery ... |