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 по дате отправления: