Re: gen_random_uuid key collision

On 9/2/21 4:38 PM, jesusthefrog wrote:
> On Thu, Sep 2, 2021 at 7:35 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto: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 

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.klaver@aklaver.com