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.