Re: gen_random_uuid key collision

Поиск
Список
Период
Сортировка
От jesusthefrog
Тема Re: gen_random_uuid key collision
Дата
Msg-id CAH_wARuTOGRY42DDtSw87y=q85eZq=j+mGjG53B6LUhxAXrnYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: gen_random_uuid key collision  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: gen_random_uuid key collision  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Thu, Sep 2, 2021 at 7:35 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
What is the table schema as returned by \d <table> in psql?


The tables are in various schemas; that one is in one called "access_control", but we always set the search path explicitly to (in this case) "access_control, public".
Anyway, if if were a problem with finding the function, I would be seeing a different error .The function successfully runs, it is just (apparently) occasionally generating the same UUID multiple times.

--
-----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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: gen_random_uuid key collision
Следующее
От: Tom Lane
Дата:
Сообщение: Re: gen_random_uuid key collision