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

Re: BUG #4274: uuid returns duplicate values

From: "Eric P(dot) Melbardis" <eric(dot)melbardis(at)netkitsolutions(dot)com>
To: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4274: uuid returns duplicate values
Date: 2008-07-01 17:35:31
Message-ID: EF3FC357692A7A418A0D4CA7ACE7F4F20296B9F1@mail.netkitsolutions.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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 = dfde33d4-188a-4124-847d-0871a90be1fa
psql:q.sql:152: NOTICE:  uuid = dfde33d4-188a-4124-847d-0871a90be1fa
psql:q.sql:152: NOTICE:  uuid = e6e5dd64-5a1b-4f2e-8443-829d3b325247
psql:q.sql:152: NOTICE:  uuid = 2bb08ab3-eb57-42a3-a9ac-63e466384d71


-----Original Message-----
From: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp] 
Sent: Sunday, June 29, 2008 3:22 PM
To: Eric P. Melbardis
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values

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(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' ;
>
>-- 
>Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-bugs

In response to

Responses

pgsql-bugs by date

Next:From: Avilio AlarcónDate: 2008-07-01 17:44:28
Subject: problema con pg_dum
Previous:From: Tom LaneDate: 2008-07-01 16:05:21
Subject: Re: BUG #4277: Feature request inet type cast numeric values

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