Re: Primary keys and composite unique keys(basic question)

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Primary keys and composite unique keys(basic question)
Дата
Msg-id c31a36a5-feda-f195-6a17-6a90627bb1e4@gmail.com
обсуждение исходный текст
Ответ на Re: Primary keys and composite unique keys(basic question)  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: Primary keys and composite unique keys(basic question)  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Re: Primary keys and composite unique keys(basic question)  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
On 4/1/21 8:28 PM, Merlin Moncure wrote:
>
> This is one of the great debates in computer science and it is not
> settled.  There are various tradeoffs around using a composite key
> derived from the data (aka natural key) vs generated identifiers. It's
> a complex topic with many facets: performance, organization,
> validation, and correctness are all relevant considerations.  I would
> never use UUIDS for keys though.
>
> merlin
>
>
And, pray tell, for what exactly would you use universally unique 
identifiers.



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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Primary keys and composite unique keys(basic question)
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Have I found an interval arithmetic bug?