Hello Peter,
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.
Patch applies cleanly.
However it does not compile, it fails on: "Duplicate OIDs detected: 3429".
Someone inserted a new entry since it was produced.
I'm wondering whether pg_random_uuid() should be taken out of pgcrypto if
it is available in core?
--
Fabien.
