Re: gen_random_uuid key collision

From: jesusthefrog <jesusthefrog(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: gen_random_uuid key collision
Date: 2021-09-03 00:36:55
Message-ID: CAH_wARtM00xdpOFgbKB-Gec0fFLZh4fzWZXpLFzpCkU0kn0WNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 2, 2021 at 7:47 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>
> BTW, are you *entirely* certain that your application never inserts
> non-default values into that column?
>
> regards, tom lane
>

Yes, I double checked that we never attempt to bind a value for that
column. I'll have a go at just rebuilding the pkey index and see if that
helps.

--
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GIT d- s+ a- C++++ L+++ S++ B+ P++>++++ E++ W+++
N o? K- !w++++ O- M- V? PS++ PE- Y+ PGP t+ 5+++
X R+ tv b+++ DI++ D++ G+ e-- h- r++ y
------END GEEK CODE BLOCK------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jesusthefrog 2021-09-03 00:38:26 Re: gen_random_uuid key collision
Previous Message Adrian Klaver 2021-09-03 00:05:26 Re: gen_random_uuid key collision