Re: pervasiveness of surrogate (also called synthetic) keys - Mailing list pgsql-general

From Scott Ribe
Subject Re: pervasiveness of surrogate (also called synthetic) keys
Date
Msg-id C569B12E-23B2-4DFF-868F-5AC2658D1460@elevated-dev.com
Whole thread Raw
In response to Re: pervasiveness of surrogate (also called synthetic) keys  (Rob Sargent <robjsargent@gmail.com>)
List 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
thefamily. And guess what? The scheme, which had been stable for 20+ years, had to change when a new variant of product
wasintroduced which cut across family & product. I don't remember the details. I do remember that I hadn't used the
supposedlystable product ids as PKs ;-) 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help with database recovery ...
Next
From: Tom Lane
Date:
Subject: Re: Seg Fault in backend after beginning to use xpath (PG 9.0, FreeBSD 8.1)