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

Meetesh Karia <meetesh.karia@gmail.com> 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?

            regards, tom lane