Search Postgresql Archives

Re: gen_random_uuid key collision

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux