From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, David Fetter <david(at)fetter(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jose Luis Tallon <jltallon(at)adv-solutions(dot)net> |
Subject: | Re: [PATCH] Implement uuid_version() |
Date: | 2019-06-11 08:49:17 |
Message-ID: | 6a65610c-46fc-2323-6b78-e8086340a325@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2019-04-09 08:04, Peter Eisentraut wrote:
> On 2019-04-08 23:06, Andres Freund wrote:
>> The randomness based UUID generators don't really have dependencies, now
>> that we have a dependency on strong randomness. I kinda thing the
>> dependency argument actually works *against* uuid-ossp - precisely
>> because of its dependencies (which also vary by OS) it's not a proper
>> replacement for a type of facility a very sizable fraction of our users
>> need.
>
> Yeah, I think implementing a v4 generator in core would be trivial and
> address almost everyone's requirements.
Here is a proposed patch for this. I did a fair bit of looking around
in other systems for a naming pattern but didn't find anything
consistent. So I ended up just taking the function name and code from
pgcrypto.
As you can see, the code is trivial and has no external dependencies. I
think this would significantly upgrade the usability of the uuid type.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment | Content-Type | Size |
---|---|---|
0001-Add-gen_random_uuid-function.patch | text/plain | 7.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Etsuro Fujita | 2019-06-11 09:09:20 | Re: BEFORE UPDATE trigger on postgres_fdw table not work |
Previous Message | Heikki Linnakangas | 2019-06-11 08:31:15 | Re: pgbench rate limiting changes transaction latency computation |