Re: Sequence vs UUID

From: Benedict Holland <benedict(dot)m(dot)holland(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Sequence vs UUID
Date: 2023-02-02 23:26:30
Message-ID: CAD+mzowOMV1tCnoKvvZs3CwYAj1T9wS9jWPMPdT7zSrvUMXWgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No idea at all. We had the data for the insert and had to insert it again.
It was extremely confusing but oh boy did it wreck our systems.

Thanks,
Ben

On Thu, Feb 2, 2023, 6:17 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> On 2/2/23 17:11, Peter J. Holzer wrote:
> > On 2023-02-02 10:22:09 -0500, Benedict Holland wrote:
> >> Well... until two processes generate an identical UUID. That happened
> to me
> >> several times.
> > How did that happen? Pure software implementation with non-random seed?
> > Hardware with insufficient entropy source?
>
> Poorly implemented algorithm?
>
> --
> Born in Arizona, moved to Babylonia.
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Smith 2023-02-03 00:41:12 Re: Support logical replication of DDLs
Previous Message Ron 2023-02-02 23:17:29 Re: Sequence vs UUID