From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | jesusthefrog <jesusthefrog(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: gen_random_uuid key collision |
Date: | 2021-09-03 00:05:26 |
Message-ID: | 2972999b-cd4b-c889-74f8-fb8a96413707@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 9/2/21 4:38 PM, jesusthefrog wrote:
> On Thu, Sep 2, 2021 at 7:35 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto: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
But only one is generating errors. Schema refers to an object's
definition as well as a namespace. So what does:
\d <table>
return?
> "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------
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | jesusthefrog | 2021-09-03 00:36:55 | Re: gen_random_uuid key collision |
Previous Message | Tom Lane | 2021-09-02 23:47:55 | Re: gen_random_uuid key collision |