Re: BUG #4274: uuid returns duplicate values - Mailing list pgsql-bugs

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:      eric.melbardis@netkitsolutions.com
>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