Re: [PATCH] Implement uuid_version()

From: Jose Luis Tallon <jltallon(at)adv-solutions(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Implement uuid_version()
Date: 2019-04-07 13:38:44
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 6/4/19 18:35, Tom Lane wrote:
> Jose Luis Tallon <jltallon(at)adv-solutions(dot)net> writes:
>>     While working on an application, the need arose to be able
>> efficiently differentiate v4/v5 UUIDs (for use in partial indexes, among
>> others)
>> ... so please find attached a trivial patch which adds the
>> functionality.
> No particular objection...
>>     I'm not sure whether this actually would justify a version bump for
>> the OSSP-UUID extension
> Yes. Basically, once we've shipped a given version of an extension's
> SQL script, that version is *frozen*. Anything at all that you want
> to do to it has to be done in an extension update script, because
> otherwise there's no clean migration path for users.

Got it, and done. Please find attached a v2 patch with the upgrade
script included.

Thank you for taking a look. Your time is much appreciated :)


Attachment Content-Type Size
uuid_version-v2.patch text/x-patch 3.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2019-04-07 13:55:31 Re: Speed up transaction completion faster after many relations are accessed in a transaction
Previous Message Magnus Hagander 2019-04-07 13:06:56 Re: pg_rewind vs superuser