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