Re: Surrogate keys (Was: enums)

Поиск
Список
Период
Сортировка
От Leandro Guimarães Faria Corcete DUTRA
Тема Re: Surrogate keys (Was: enums)
Дата
Msg-id loom.20060118T141047-101@post.gmane.org
обсуждение исходный текст
Ответ на Re: enums  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: Surrogate keys (Was: enums)  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Greg Stark <gsstark <at> mit.edu> writes:

> I hate knee-jerk reactions too, but just think of all the pain of people
> dealing with databases where they used Social Security numbers for primary
> keys. I would never use an attribute that represents some real-world datum as
> a primary key any more.

I am not familiar with the situation.


> In my experience there are very few occasions where I want a real non-sequence
> generated primary key. I've never regretted having a sequence generated
> primary key, and I've certainly had occasions to regret not having one.

http://blogs.ittoolbox.com/database/soup/archives/007327.asp?rss=1




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Leandro Guimarães Faria Corcete DUTRA
Дата:
Сообщение: Re: Surrogate keys (Was: enums)
Следующее
От: Leandro Guimarães Faria Corcete DUTRA
Дата:
Сообщение: Re: enums