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

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Primary keys and composite unique keys(basic question)
Date: 2021-04-02 03:26:30
Message-ID: c31a36a5-feda-f195-6a17-6a90627bb1e4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2021-04-02 04:46:58 Have I found an interval arithmetic bug?
Previous Message Merlin Moncure 2021-04-02 02:28:59 Re: Primary keys and composite unique keys(basic question)