Re: [PATCH] Implement uuid_version()

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Andres Freund <andres@anarazel.de>, Robert Haas <robertmhaas@gmail.com>, David Fetter <david@fetter.org>, Tom Lane <tgl@sss.pgh.pa.us>, Jose Luis Tallon <jltallon@adv-solutions.net>
Date: 2019-06-11T08:49:17Z
Lists: pgsql-hackers

Attachments

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

Commits

  1. Add gen_random_uuid function

  2. Add a 64-bit hash function for type hstore.