Re: [BUGS] BUG #14670: uuid_generate_v3 and uuid_generate_v5 do not support binary names

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14670: uuid_generate_v3 and uuid_generate_v5 do not support binary names
Дата
Msg-id 15138.1495666113@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14670: uuid_generate_v3 and uuid_generate_v5 do notsupport binary names  (Mohamed Akram <mohd.akram@outlook.com>)
Ответы Re: [BUGS] BUG #14670: uuid_generate_v3 and uuid_generate_v5 do notsupport binary names  (Mohamed Akram <mohd.akram@outlook.com>)
Список pgsql-bugs
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,
eventhe 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


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Mohamed Akram
Дата:
Сообщение: Re: [BUGS] BUG #14670: uuid_generate_v3 and uuid_generate_v5 do notsupport binary names
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14637: Tests fail with pl_PL.UTF-8 locale