Postgres Pro
Downloads
Home   >   mailing lists

Re: gen_random_uuid key collision - Mailing list pgsql-general

From jesusthefrog
Subject Re: gen_random_uuid key collision
Date
Msg-id CAH_wARtM00xdpOFgbKB-Gec0fFLZh4fzWZXpLFzpCkU0kn0WNA@mail.gmail.com
Whole thread Raw
In response to Re: gen_random_uuid key collision  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On Thu, Sep 2, 2021 at 7:47 PM Tom Lane <tgl@sss.pgh.pa.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------

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: gen_random_uuid key collision
Next
From: jesusthefrog
Date:
Subject: Re: gen_random_uuid key collision