Tom Lane wrote:
Meetesh Karia <[EMAIL PROTECTED]> writes:
As best as I can tell, the problem is caused because generation of v1
UUIDs uses GetSystemTimeAsFileTime which is stated to have a resolution
of 100 nanoseconds but in practice has a resolution of around 15ms
(http://www.ddj.com/showArticle.jhtml?documentID=win0305a&pgno=17).
Well, any real-time clock reading is going to have finite resolution.
If your app is expecting that version-1 UUIDs generated in rapid
succession will be distinct, I think your app is broken. It's just
a little more obvious on Windows :-(.
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
Stefan
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs