| From: | jesusthefrog <jesusthefrog(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: gen_random_uuid key collision |
| Date: | 2021-09-02 23:38:07 |
| Message-ID: | CAH_wARuTOGRY42DDtSw87y=q85eZq=j+mGjG53B6LUhxAXrnYQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 2, 2021 at 7:35 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-09-02 23:47:55 | Re: gen_random_uuid key collision |
| Previous Message | Adrian Klaver | 2021-09-02 23:35:17 | Re: gen_random_uuid key collision |