Sunday, June 29, 2008

[BUGS] BUG #4274: uuid returns duplicate values

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

No comments: