Re: pervasiveness of surrogate (also called synthetic) keys

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: pervasiveness of surrogate (also called synthetic) keys
Дата
Msg-id C569B12E-23B2-4DFF-868F-5AC2658D1460@elevated-dev.com
обсуждение исходный текст
Ответ на Re: pervasiveness of surrogate (also called synthetic) keys  (Rob Sargent <robjsargent@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Help with database recovery ...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Seg Fault in backend after beginning to use xpath (PG 9.0, FreeBSD 8.1)