Hi I just tried it, slightly better but not a runner....
Here is a sample of the results I get when running my test script, note result vary but lack of duplicates does not. Why do you not use the CreateUUID function in windows?? Regards Eric ------------------------ result ------------------------------------ psql:q.sql:152: NOTICE: uuid = dfde33d4-188a-4124-847d-0871a90be1fa psql:q.sql:152: NOTICE: uuid = dfde33d4-188a-4124-847d-0871a90be1fa psql:q.sql:152: NOTICE: uuid = e6e5dd64-5a1b-4f2e-8443-829d3b325247 psql:q.sql:152: NOTICE: uuid = 2bb08ab3-eb57-42a3-a9ac-63e466384d71 -----Original Message----- From: Hiroshi Saito [mailto:[EMAIL PROTECTED] Sent: Sunday, June 29, 2008 3:22 PM To: Eric P. Melbardis Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values Hi. I'm sorry delaying release bugfix was not included in pg8.3.3. Please try this. http://winpg.jp/~saito/pg_work/OSSP_win32/ Regards, Hiroshi Saito > >The following bug has been logged online: > >Bug reference: 4274 >Logged by: eric melbardis >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.3.3 >Operating system: windows xp sp3 >Description: uuid returns duplicate values >Details: > >the uuid functions do not return unique values if used sequntially, or i >believe without too much tme in between invocations. > >the following test functions returns the same value! > >------------ test function --------------- >create or replace function test_uuid() >returns varchar as >$body$ >begin > raise notice 'uuid = %', uuid_generate_v4(); > raise notice 'uuid = %', uuid_generate_v4(); > raise notice 'uuid = %', uuid_generate_v4(); > raise notice 'uuid = %', uuid_generate_v4(); >end; >$body$ >language 'plpgsql' ; > >-- >Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-bugs -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
