Postgres Pro
Downloads
Home   >   mailing lists

Re: Sequence vs UUID - Mailing list pgsql-general

From Benedict Holland
Subject Re: Sequence vs UUID
Date
Msg-id CAD+mzowOMV1tCnoKvvZs3CwYAj1T9wS9jWPMPdT7zSrvUMXWgg@mail.gmail.com
Whole thread Raw
In response to Re: Sequence vs UUID  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Sequence vs UUID  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view
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@gmail.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.


pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Sequence vs UUID
Next
From: Rob Sargent
Date:
Subject: Re: Sequence vs UUID