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 =3D dfde33d4-188a-4124-847d-0871a90be1fa
psql:q.sql:152: NOTICE: uuid =3D dfde33d4-188a-4124-847d-0871a90be1fa
psql:q.sql:152: NOTICE: uuid =3D e6e5dd64-5a1b-4f2e-8443-829d3b325247
psql:q.sql:152: NOTICE: uuid =3D 2bb08ab3-eb57-42a3-a9ac-63e466384d71
-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]=20
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.=20
Please try this.=20
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: eric.melbardis@netkitsolutions.com
>PostgreSQL version: 8.3.3
>Operating system: windows xp sp3
>Description: uuid returns duplicate values
>Details:=20
>
>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=20
>$body$
>begin
> raise notice 'uuid =3D %', uuid_generate_v4();
> raise notice 'uuid =3D %', uuid_generate_v4();
> raise notice 'uuid =3D %', uuid_generate_v4();
> raise notice 'uuid =3D %', uuid_generate_v4();
>end;
>$body$
>language 'plpgsql' ;
>
>--=20
>Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-bugs