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

2008-06-17 Thread Meetesh Karia
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-uui

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

2008-06-17 Thread Dave Page
On Tue, Jun 17, 2008 at 11:17 AM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: > Hi. > > Please this. > http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/ Ahh, a makefile - that makes things somewhat clearer :-) Thanks - I've updated the build machine so future releases will include this fix. -- Dave

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

2008-06-17 Thread Hiroshi Saito
Hi. Please this. http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/ P.S) sorry, It did not have a machine, when it mailed with you before. Regards, Hiroshi Saito - Original Message - From: "Dave Page" <[EMAIL PROTECTED]> On Tue, Jun 17, 2008 at 10:25 AM, Hiroshi Saito <[EMAIL PROTE

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

2008-06-17 Thread Dave Page
On Tue, Jun 17, 2008 at 10:25 AM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: > Hi. > > Um, I will arrange information and write wiki. . Is it a suitable place? A README file at http://winpg.jp/~saito/pg_work/OSSP_win32/ would be enough. > This is some information. http://winpg.jp/~saito/pg_work/OSS

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

2008-06-17 Thread Hiroshi Saito
Hi. Um, I will arrange information and write wiki. . Is it a suitable place? This is some information. http://winpg.jp/~saito/pg_work/OSSP_win32/ uuid-ossp.dll(MinGW compile) is this. http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp.zip Regards, Hiroshi Saito - Origi

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

2008-06-17 Thread Dave Page
On Tue, Jun 17, 2008 at 5:21 AM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: > Hi. > > Sorry, late the information. > My patch was applied after the review of Ralf-san. However, The timing of a > release was different. Then, patch is only current CVS-HEAD. > http://cvs.ossp.org/chngview?cn=6001 >

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

2008-06-16 Thread Hiroshi Saito
Hi. Sorry, late the information. My patch was applied after the review of Ralf-san. However, The timing of a release was different. Then, patch is only current CVS-HEAD. http://cvs.ossp.org/chngview?cn=6001 I thought that this problem was very important. It was sufficient reason to apply

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

2008-06-16 Thread Tom Lane
Stefan Kaltenbrunner <[EMAIL PROTECTED]> 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/m

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

2008-06-16 Thread Stefan Kaltenbrunner
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/showArt

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

2008-06-16 Thread Tom Lane
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

[BUGS] UUIDs generated using ossp-uuid on windows not unique

2008-06-16 Thread Meetesh Karia
Hi all, This may not be the appropriate list to discuss this on (since it looks like the bug is in the underlying library), but as the win32 port was done because of postgresql (as far as I can tell), I wanted to see if anyone had run into this and/or had any workarounds: As best as I can te