Re: UUIDs generated using ossp-uuid on windows not unique - Mailing list pgsql-bugs

From Meetesh Karia
Subject Re: UUIDs generated using ossp-uuid on windows not unique
Date
Msg-id 485798CB.2090505@gmail.com
Whole thread Raw
In response to Re: UUIDs generated using ossp-uuid on windows not unique  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Dave Page"
Date:
Subject: Re: UUIDs generated using ossp-uuid on windows not unique
Next
From: "Tatsuhito Kasahara"
Date:
Subject: BUG #4244: ALTER TABLE ... NO INHERIT problem