Re: [BUGS] BUG #14670: uuid_generate_v3 and uuid_generate_v5 do notsupport binary names - Mailing list pgsql-bugs

From Mohamed Akram
Subject Re: [BUGS] BUG #14670: uuid_generate_v3 and uuid_generate_v5 do notsupport binary names
Date
Msg-id B52469FF-8C94-4037-972E-AC63A7BA27A2@outlook.com
Whole thread Raw
In response to Re: [BUGS] BUG #14670: uuid_generate_v3 and uuid_generate_v5 do not support binary names  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I’ve attached a patch for this.

Regards,
Mohamed


> On May 25, 2017, at 2:48 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Mohamed Akram <mohd.akram@outlook.com> writes:
>> That’s true, I guess it’s more of an enhancement but I couldn’t find an option for that in the bug form. However, even the sample C code in the RFC takes a void* argument for name.
>> My use case is generating unique identifiers for images, similar to:
>> select uuid_generate_v5(namespace, data);
>> where data is a bytea column.
>
> A little experimentation suggests that we might be able to add a function
> uuid_generate_v3(uuid, bytea) alongside the uuid_generate_v3(uuid, text)
> one without creating serious problems --- in ambiguous situations, it
> seems the text one would be preferred, so we'd not break existing queries.
>
> I have no interest in preparing such a patch myself, though.
>
>                        regards, tom lane

Attachment

pgsql-bugs by date:

Previous
From: Chapman Flack
Date:
Subject: Re: [BUGS] [HACKERS] Re: Postgresql bug report - unexpected behaviorof suppress_redundant_updates_trigger
Next
From: Bruno Wolff III
Date:
Subject: [BUGS] Beta 10 parser error for CREATE STATISTICS IF NOT EXISTS