Skip site navigation (1) Skip section navigation (2)

BUG #4274: uuid returns duplicate values

From: "eric melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4274: uuid returns duplicate values
Date: 2008-06-29 16:21:56
Message-ID: 200806291621.m5TGLuJX095219@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4274
Logged by:          eric melbardis
Email address:      eric(dot)melbardis(at)netkitsolutions(dot)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' ;

pgsql-bugs by date

Next:From: Alexey BashtanovDate: 2008-06-29 16:25:06
Subject: Re: BUG #4271: dropped columns conflict with returning rules
Previous:From: Tom LaneDate: 2008-06-29 15:49:58
Subject: Re: BUG #4271: dropped columns conflict with returning rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group