Re: UUIDs generated using ossp-uuid on windows not unique

Поиск
Список
Период
Сортировка
От Meetesh Karia
Тема Re: UUIDs generated using ossp-uuid on windows not unique
Дата
Msg-id 485798CB.2090505@gmail.com
обсуждение исходный текст
Ответ на Re: UUIDs generated using ossp-uuid on windows not unique  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Using the dll from the link that Hiroshi posted actually fixed v1 in my
case (though perhaps it's just an unrelated side-effect caused by using
a different random number generator which might be slower???).  Thanks!

Anyhow, I would have expected v1 to work fine in this case too as the
ossp-uuid implementation has provisions for preventing overlapping ids
when they're generated in rapid succession.  And, as I was only
generating about 1 uuid/ms, I didn't think that would be pushing the
limits of the algorithm.

Thanks again everyone,
Meetesh

Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
>
>> Tom Lane wrote:
>>
>>> Perhaps the v4 generation method would work better for you?
>>>
>
>
>> actually this has been reported before and seems to be an issue in the
>> windows port of the ossp-uuid library:
>> http://archives.postgresql.org/pgsql-bugs/2008-05/msg00059.php
>>
>
> Oh, so that doesn't work either :-(.  However, at least it's been
> fixed upstream:
> http://archives.postgresql.org/pgsql-bugs/2008-05/msg00070.php
> http://cvs.ossp.org/pkg/lib/uuid/ChangeLog
>
>             regards, tom lane
>

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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: UUIDs generated using ossp-uuid on windows not unique
Следующее
От: "Tatsuhito Kasahara"
Дата:
Сообщение: BUG #4244: ALTER TABLE ... NO INHERIT problem