Re: Primary keys and composite unique keys(basic question) - Mailing list pgsql-general

From Hemil Ruparel
Subject Re: Primary keys and composite unique keys(basic question)
Date
Msg-id CANW1aT97xBzo0XoPeEuo2NZr6SAMU+dCs5mCLVOpom0aYOLvOQ@mail.gmail.com
Whole thread Raw
In response to Re: Primary keys and composite unique keys(basic question)  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Primary keys and composite unique keys(basic question)  (Bertrand Mamasam <golgote@gmail.com>)
List pgsql-general
I used uuid4 for customer ids because i needed to interface with payment providers. Is that wrong? All other places except transaction ids, i have used serial ints

On Fri 2 Apr, 2021, 8:56 AM Rob Sargent, <robjsargent@gmail.com> wrote:
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 by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Have I found an interval arithmetic bug?
Next
From: Pierre Forstmann
Date:
Subject: Re: Copy Statistics Tables During Upgrade