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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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' ;
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Bashtanov | 2008-06-29 16:25:06 | Re: BUG #4271: dropped columns conflict with returning rules |
Previous Message | Tom Lane | 2008-06-29 15:49:58 | Re: BUG #4271: dropped columns conflict with returning rules |