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
- 0001-Add-gen_random_uuid-function.patch (text/plain) patch 0001
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
-
Add gen_random_uuid function
- 5925e5549890 13.0 landed
-
Add a 64-bit hash function for type hstore.
- eb6f29141bed 12.0 cited