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

Hi.

This can obtain a comfortable result.
http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080706.zip

I will adjust with Rarf-san.
Thanks!

Regards,
Hiroshi Saito

----- Original Message -----
From: "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>
To: "Eric P. Melbardis" <eric.melbardis@netkitsolutions.com>; "Nicolas ANTONINI"
<nicolas.antonini@mnm-consulting.com>
Cc: <pgsql-bugs@postgresql.org>
Sent: Saturday, July 05, 2008 1:28 AM
Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values


> Hi.
>
> uuid of MS is the approach different from ossp. Then, I regret that it can't provide on
> other platforms....But, I tried it.
> http://winpg.jp/~saito/pg_work/OSSP_win32/try-uuidwin32/
> If someone wishes, I think that this is the place where pgfoundry is suitable.
> Therefore, I will work an effort to clear the bug of uuid-ossp persistently. Please give
> me time to a slight degree.
> I appreciate your perseverance. thanks!
>
> Regards,
> Hiroshi Saito
>
>> ----- Original Message -----
>> From: "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>
>>
>>> Hi.
>>>
>>> Sorry,  late reaction....Now, private time has only a few.
>>> Umm, It seems that the bug is probably contained in another part. I will investigate at
>>> a weekend again.
>>>
>>> Anyway, thank you for useful information.!
>>>
>>> Regards,
>>> Hiroshi Saito
>>>
>>> ----- Original Message -----
>>> From: "Eric P. Melbardis" <eric.melbardis@netkitsolutions.com>
>>>
>>>
>>> Hi
>>>
>>>
>>> I would suspect that the clock used may not be precise enough
>>>
>>> Not with standing, why not use the windows CreateUUID??
>>>
>>> Slower system seems to fare better... (please see results below)
>>>
>>> Regards
>>>
>>> Eric
>>>
>>>
>>> -------------------
>>> My office system is xeon (duo core 5160) 3.00 ghz, 2 gig-ram
>>>
>>> psql:q.sql:168: INFO:  uuid = b2631eb7-26ad-4b40-9276-ed1fc43f0944
>>> psql:q.sql:168: INFO:  uuid = 45472e3e-a88e-46ff-b2b1-cfa229b8c568
>>> psql:q.sql:168: INFO:  uuid = 45472e3e-a88e-46ff-b2b1-cfa229b8c568
>>> psql:q.sql:168: INFO:  uuid = 45472e3e-a88e-46ff-b2b1-cfa229b8c568
>>> psql:q.sql:168: INFO:  uuid = 45472e3e-a88e-46ff-b2b1-cfa229b8c568
>>> psql:q.sql:168: INFO:  uuid = 45472e3e-a88e-46ff-b2b1-cfa229b8c568
>>> psql:q.sql:168: INFO:  uuid = 45472e3e-a88e-46ff-b2b1-cfa229b8c568
>>> psql:q.sql:168: INFO:  uuid = 45472e3e-a88e-46ff-b2b1-cfa229b8c568
>>> psql:q.sql:168: INFO:  uuid = efd009ab-c38b-4efa-8b0c-4ef0280dc781
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
>>> psql:q.sql:168: INFO:  uuid = abc4884d-273e-49ce-82aa-46226af549c3
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 5d5fce48-987a-46e9-ac03-e567e703aafb
>>> psql:q.sql:168: INFO:  uuid = 6c3da39d-467e-484c-9b68-6a20f8980c3a
>>> psql:q.sql:168: INFO:  uuid = 6c3da39d-467e-484c-9b68-6a20f8980c3a
>>> psql:q.sql:168: INFO:  uuid = 6c3da39d-467e-484c-9b68-6a20f8980c3a
>>> psql:q.sql:168: INFO:  uuid = 6c3da39d-467e-484c-9b68-6a20f8980c3a
>>> psql:q.sql:168: INFO:  uuid = 6c3da39d-467e-484c-9b68-6a20f8980c3a
>>> psql:q.sql:168: INFO:  uuid = 6c3da39d-467e-484c-9b68-6a20f8980c3a
>>> psql:q.sql:168: INFO:  uuid = 6c3da39d-467e-484c-9b68-6a20f8980c3a
>>> psql:q.sql:168: INFO:  uuid = 6c3da39d-467e-484c-9b68-6a20f8980c3a
>>> psql:q.sql:168: INFO:  uuid = 754268bc-411d-48dd-b68d-5b449c18ecab
>>> psql:q.sql:168: INFO:  uuid = a0ae6b93-adec-4523-b422-8eba041d76de
>>> -----
>>>
>>> -------------------
>>> My home system is Pentium D 3.2 hz 2g ram (NON-xeon!)
>>>
>>> psql:q.sql:168: INFO:  uuid = 5dce8d5f-0f36-40fc-a34c-af74991e7fb3
>>> psql:q.sql:168: INFO:  uuid = ae9b28c3-1614-4092-93dd-ba1d8392622c
>>> psql:q.sql:168: INFO:  uuid = ae9b28c3-1614-4092-93dd-ba1d8392622c
>>> psql:q.sql:168: INFO:  uuid = 14146307-231e-4feb-aa97-a709f6515d05
>>> psql:q.sql:168: INFO:  uuid = 6a70d36c-de75-44ca-947b-3785eac42d49
>>> psql:q.sql:168: INFO:  uuid = 6a70d36c-de75-44ca-947b-3785eac42d49
>>> psql:q.sql:168: INFO:  uuid = 849650aa-1004-4c28-b7b5-dce9bcff22e4
>>> psql:q.sql:168: INFO:  uuid = f950d8d9-c257-41cc-8206-7267698755f1
>>> psql:q.sql:168: INFO:  uuid = f950d8d9-c257-41cc-8206-7267698755f1
>>> psql:q.sql:168: INFO:  uuid = f950d8d9-c257-41cc-8206-7267698755f1
>>> psql:q.sql:168: INFO:  uuid = df203405-a3d9-40b8-8195-46cdc7a9aa09
>>> psql:q.sql:168: INFO:  uuid = c7ac43bc-2355-4c4d-9b61-defefead41e1
>>> psql:q.sql:168: INFO:  uuid = c7ac43bc-2355-4c4d-9b61-defefead41e1
>>> psql:q.sql:168: INFO:  uuid = e6a40257-5095-441a-8216-4802b8ccceca
>>> psql:q.sql:168: INFO:  uuid = d10df458-a372-4ff8-85f5-c6fb8bcdf798
>>> psql:q.sql:168: INFO:  uuid = d10df458-a372-4ff8-85f5-c6fb8bcdf798
>>> psql:q.sql:168: INFO:  uuid = d10df458-a372-4ff8-85f5-c6fb8bcdf798
>>> psql:q.sql:168: INFO:  uuid = 3ff3189b-cbe9-4e7f-b76e-0953337242b1
>>> psql:q.sql:168: INFO:  uuid = 210a9418-1e19-4bec-b7ca-a0333d7dbb02
>>> psql:q.sql:168: INFO:  uuid = 210a9418-1e19-4bec-b7ca-a0333d7dbb02
>>> psql:q.sql:168: INFO:  uuid = 68bfec27-6f9d-49c7-93fc-4218a1d32e18
>>> psql:q.sql:168: INFO:  uuid = ef86cb1b-2721-4a74-ba21-64fe5148c9d7
>>> psql:q.sql:168: INFO:  uuid = ef86cb1b-2721-4a74-ba21-64fe5148c9d7
>>> psql:q.sql:168: INFO:  uuid = ef86cb1b-2721-4a74-ba21-64fe5148c9d7
>>> psql:q.sql:168: INFO:  uuid = 45141a17-9972-4013-92f2-ced9215f45b5
>>> psql:q.sql:168: INFO:  uuid = 7c6cbb39-af9f-4de6-b6f8-0ae57bf0ea4f
>>> psql:q.sql:168: INFO:  uuid = 7c6cbb39-af9f-4de6-b6f8-0ae57bf0ea4f
>>> psql:q.sql:168: INFO:  uuid = 59d4c7ff-598d-49ae-9a95-a4051c2b5787
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp] Sent: Tuesday, July 01, 2008 4:56
>>> PM
>>> To: Eric P. Melbardis
>>> Cc: pgsql-bugs@postgresql.org
>>> Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values
>>>
>>> Hi.
>>>
>>> Umm...
>>> The test of my box is comfortable. --
>>> -- ossp-uuid test
>>> --
>>> CREATE OR REPLACE FUNCTION test_uuid(gen INTEGER)
>>>  RETURNS VOID AS $$
>>> BEGIN
>>> FOR i IN 1..$1 LOOP
>>>  RAISE INFO 'uuid = %', uuid_generate_v4();
>>> END LOOP;
>>> END;
>>> $$
>>> LANGUAGE 'plpgsql';
>>>
>>> postgres=# CREATE OR REPLACE FUNCTION test_uuid(gen INTEGER)
>>> postgres-#   RETURNS VOID AS $$
>>> postgres$# BEGIN
>>> postgres$#  FOR i IN 1..$1 LOOP
>>> postgres$#   RAISE INFO 'uuid = %', uuid_generate_v4();
>>> postgres$#  END LOOP;
>>> postgres$# END;
>>> postgres$# $$
>>> postgres-# LANGUAGE 'plpgsql';
>>> CREATE FUNCTION
>>> postgres=# SELECT test_uuid(10);
>>> INFO:  uuid = 427c6f3e-9876-48c5-b44d-776771f7c2c9
>>> INFO:  uuid = fbab93a8-44d2-4f52-b6ae-01396c6ee17e
>>> INFO:  uuid = d82be630-d2e8-4662-b6ea-db8c56121024
>>> INFO:  uuid = 33689404-2da8-4a8d-9b94-6aeb284be347
>>> INFO:  uuid = cd7d10b7-23fa-40df-af74-53314dae235c
>>> INFO:  uuid = 80934b57-4cf4-4ab5-b915-f41f22054265
>>> INFO:  uuid = abd6f205-1a49-4f4f-b854-c7d611533401
>>> INFO:  uuid = 2dd64cbc-ee86-419e-ba09-ae538f60cc5a
>>> INFO:  uuid = 751ee0fe-d5ae-473f-b22f-e14c9066fadd
>>> INFO:  uuid = 0d36e47d-c065-4717-96f0-82f53f610a9a
>>> test_uuid
>>> -----------
>>>
>>> (1 row)
>>>
>>> Regards,
>>> Hiroshi Saito
>>>
>>> ----- Original Message -----
>>> From: "Eric P. Melbardis" <eric.melbardis@netkitsolutions.com>
>>>
>>>
>>> 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@guitar.ocn.ne.jp] Sent: Sunday, June 29, 2008 3:22
>>> PM
>>> To: Eric P. Melbardis
>>> Cc: pgsql-bugs@postgresql.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.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
>>>
>>> --
>>> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-bugs