Thread: BUG #4274: uuid returns duplicate values

BUG #4274: uuid returns duplicate values

From
"eric melbardis"
Date:
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' ;

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
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

Re: BUG #4274: uuid returns duplicate values

From
"Eric P. Melbardis"
Date:
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 =3D dfde33d4-188a-4124-847d-0871a90be1fa
psql:q.sql:152: NOTICE:  uuid =3D dfde33d4-188a-4124-847d-0871a90be1fa
psql:q.sql:152: NOTICE:  uuid =3D e6e5dd64-5a1b-4f2e-8443-829d3b325247
psql:q.sql:152: NOTICE:  uuid =3D 2bb08ab3-eb57-42a3-a9ac-63e466384d71


-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]=20
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.=20
Please try this.=20
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:=20
>
>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=20
>$body$
>begin
>    raise notice 'uuid =3D %', uuid_generate_v4();
>    raise notice 'uuid =3D %', uuid_generate_v4();
>    raise notice 'uuid =3D %', uuid_generate_v4();
>    raise notice 'uuid =3D %', uuid_generate_v4();
>end;
>$body$
>language 'plpgsql' ;
>
>--=20
>Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
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

Re: BUG #4274: uuid returns duplicate values

From
"Eric P. Melbardis"
Date:
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 =3D b2631eb7-26ad-4b40-9276-ed1fc43f0944
psql:q.sql:168: INFO:  uuid =3D 45472e3e-a88e-46ff-b2b1-cfa229b8c568
psql:q.sql:168: INFO:  uuid =3D 45472e3e-a88e-46ff-b2b1-cfa229b8c568
psql:q.sql:168: INFO:  uuid =3D 45472e3e-a88e-46ff-b2b1-cfa229b8c568
psql:q.sql:168: INFO:  uuid =3D 45472e3e-a88e-46ff-b2b1-cfa229b8c568
psql:q.sql:168: INFO:  uuid =3D 45472e3e-a88e-46ff-b2b1-cfa229b8c568
psql:q.sql:168: INFO:  uuid =3D 45472e3e-a88e-46ff-b2b1-cfa229b8c568
psql:q.sql:168: INFO:  uuid =3D 45472e3e-a88e-46ff-b2b1-cfa229b8c568
psql:q.sql:168: INFO:  uuid =3D efd009ab-c38b-4efa-8b0c-4ef0280dc781
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D 10c8c7aa-1367-44fa-ac76-a0f9b1ca69b7
psql:q.sql:168: INFO:  uuid =3D abc4884d-273e-49ce-82aa-46226af549c3
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 5d5fce48-987a-46e9-ac03-e567e703aafb
psql:q.sql:168: INFO:  uuid =3D 6c3da39d-467e-484c-9b68-6a20f8980c3a
psql:q.sql:168: INFO:  uuid =3D 6c3da39d-467e-484c-9b68-6a20f8980c3a
psql:q.sql:168: INFO:  uuid =3D 6c3da39d-467e-484c-9b68-6a20f8980c3a
psql:q.sql:168: INFO:  uuid =3D 6c3da39d-467e-484c-9b68-6a20f8980c3a
psql:q.sql:168: INFO:  uuid =3D 6c3da39d-467e-484c-9b68-6a20f8980c3a
psql:q.sql:168: INFO:  uuid =3D 6c3da39d-467e-484c-9b68-6a20f8980c3a
psql:q.sql:168: INFO:  uuid =3D 6c3da39d-467e-484c-9b68-6a20f8980c3a
psql:q.sql:168: INFO:  uuid =3D 6c3da39d-467e-484c-9b68-6a20f8980c3a
psql:q.sql:168: INFO:  uuid =3D 754268bc-411d-48dd-b68d-5b449c18ecab
psql:q.sql:168: INFO:  uuid =3D a0ae6b93-adec-4523-b422-8eba041d76de
-----

-------------------
My home system is Pentium D 3.2 hz 2g ram (NON-xeon!)

psql:q.sql:168: INFO:  uuid =3D 5dce8d5f-0f36-40fc-a34c-af74991e7fb3
psql:q.sql:168: INFO:  uuid =3D ae9b28c3-1614-4092-93dd-ba1d8392622c
psql:q.sql:168: INFO:  uuid =3D ae9b28c3-1614-4092-93dd-ba1d8392622c
psql:q.sql:168: INFO:  uuid =3D 14146307-231e-4feb-aa97-a709f6515d05
psql:q.sql:168: INFO:  uuid =3D 6a70d36c-de75-44ca-947b-3785eac42d49
psql:q.sql:168: INFO:  uuid =3D 6a70d36c-de75-44ca-947b-3785eac42d49
psql:q.sql:168: INFO:  uuid =3D 849650aa-1004-4c28-b7b5-dce9bcff22e4
psql:q.sql:168: INFO:  uuid =3D f950d8d9-c257-41cc-8206-7267698755f1
psql:q.sql:168: INFO:  uuid =3D f950d8d9-c257-41cc-8206-7267698755f1
psql:q.sql:168: INFO:  uuid =3D f950d8d9-c257-41cc-8206-7267698755f1
psql:q.sql:168: INFO:  uuid =3D df203405-a3d9-40b8-8195-46cdc7a9aa09
psql:q.sql:168: INFO:  uuid =3D c7ac43bc-2355-4c4d-9b61-defefead41e1
psql:q.sql:168: INFO:  uuid =3D c7ac43bc-2355-4c4d-9b61-defefead41e1
psql:q.sql:168: INFO:  uuid =3D e6a40257-5095-441a-8216-4802b8ccceca
psql:q.sql:168: INFO:  uuid =3D d10df458-a372-4ff8-85f5-c6fb8bcdf798
psql:q.sql:168: INFO:  uuid =3D d10df458-a372-4ff8-85f5-c6fb8bcdf798
psql:q.sql:168: INFO:  uuid =3D d10df458-a372-4ff8-85f5-c6fb8bcdf798
psql:q.sql:168: INFO:  uuid =3D 3ff3189b-cbe9-4e7f-b76e-0953337242b1
psql:q.sql:168: INFO:  uuid =3D 210a9418-1e19-4bec-b7ca-a0333d7dbb02
psql:q.sql:168: INFO:  uuid =3D 210a9418-1e19-4bec-b7ca-a0333d7dbb02
psql:q.sql:168: INFO:  uuid =3D 68bfec27-6f9d-49c7-93fc-4218a1d32e18
psql:q.sql:168: INFO:  uuid =3D ef86cb1b-2721-4a74-ba21-64fe5148c9d7
psql:q.sql:168: INFO:  uuid =3D ef86cb1b-2721-4a74-ba21-64fe5148c9d7
psql:q.sql:168: INFO:  uuid =3D ef86cb1b-2721-4a74-ba21-64fe5148c9d7
psql:q.sql:168: INFO:  uuid =3D 45141a17-9972-4013-92f2-ced9215f45b5
psql:q.sql:168: INFO:  uuid =3D 7c6cbb39-af9f-4de6-b6f8-0ae57bf0ea4f
psql:q.sql:168: INFO:  uuid =3D 7c6cbb39-af9f-4de6-b6f8-0ae57bf0ea4f
psql:q.sql:168: INFO:  uuid =3D 59d4c7ff-598d-49ae-9a95-a4051c2b5787



-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]=20
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.=20

--
-- ossp-uuid test
--
CREATE OR REPLACE FUNCTION test_uuid(gen INTEGER)
  RETURNS VOID AS $$
BEGIN
 FOR i IN 1..$1 LOOP
  RAISE INFO 'uuid =3D %', uuid_generate_v4();
 END LOOP;
END;
$$
LANGUAGE 'plpgsql';

postgres=3D# 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 =3D %', uuid_generate_v4();
postgres$#  END LOOP;
postgres$# END;
postgres$# $$
postgres-# LANGUAGE 'plpgsql';
CREATE FUNCTION
postgres=3D# SELECT test_uuid(10);
INFO:  uuid =3D 427c6f3e-9876-48c5-b44d-776771f7c2c9
INFO:  uuid =3D fbab93a8-44d2-4f52-b6ae-01396c6ee17e
INFO:  uuid =3D d82be630-d2e8-4662-b6ea-db8c56121024
INFO:  uuid =3D 33689404-2da8-4a8d-9b94-6aeb284be347
INFO:  uuid =3D cd7d10b7-23fa-40df-af74-53314dae235c
INFO:  uuid =3D 80934b57-4cf4-4ab5-b915-f41f22054265
INFO:  uuid =3D abd6f205-1a49-4f4f-b854-c7d611533401
INFO:  uuid =3D 2dd64cbc-ee86-419e-ba09-ae538f60cc5a
INFO:  uuid =3D 751ee0fe-d5ae-473f-b22f-e14c9066fadd
INFO:  uuid =3D 0d36e47d-c065-4717-96f0-82f53f610a9a
 test_uuid
-----------

(1 row)

Regards,
Hiroshi Saito

----- Original Message -----=20
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 =3D dfde33d4-188a-4124-847d-0871a90be1fa
psql:q.sql:152: NOTICE:  uuid =3D dfde33d4-188a-4124-847d-0871a90be1fa
psql:q.sql:152: NOTICE:  uuid =3D e6e5dd64-5a1b-4f2e-8443-829d3b325247
psql:q.sql:152: NOTICE:  uuid =3D 2bb08ab3-eb57-42a3-a9ac-63e466384d71


-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]=20
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.=20
Please try this.=20
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:=20
>
>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=20
>$body$
>begin
>    raise notice 'uuid =3D %', uuid_generate_v4();
>    raise notice 'uuid =3D %', uuid_generate_v4();
>    raise notice 'uuid =3D %', uuid_generate_v4();
>    raise notice 'uuid =3D %', uuid_generate_v4();
>end;
>$body$
>language 'plpgsql' ;
>
>--=20
>Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
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

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
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

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
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

Re: BUG #4274: uuid returns duplicate values

From
Bruce Momjian
Date:
Hiroshi Saito wrote:
> 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.

Has this been completed?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
Hi.

Yes, Finally Ralf-san adjusts this patch.
http://winpg.jp/~saito/pg_work/OSSP_win32/.
Therefore, it is contained in the next release.(1.6.3/4)

Thanks!!

Regards,
Hiroshi Saito

----- Original Message -----
From: "Bruce Momjian" <bruce@momjian.us>


> Hiroshi Saito wrote:
>> 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.
>
> Has this been completed?
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #4274: uuid returns duplicate values

From
Bruce Momjian
Date:
Hiroshi Saito wrote:
> Hi.
>
> Yes, Finally Ralf-san adjusts this patch.
> http://winpg.jp/~saito/pg_work/OSSP_win32/.
> Therefore, it is contained in the next release.(1.6.3/4)

OK, good.  Does any of this get applied to contrib/uuid-ossp?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Re: BUG #4274: uuid returns duplicate values

From
"Eric P. Melbardis"
Date:
Hi

I downloaded the latest version from the specified url.
Put dll in the postgres "C:\Program Files\PostgreSQL\8.3\lib" directory, an=
d restarted postgres service


Sorry, still does not work!

nkworks3=3D# SELECT test_uuid(10);
INFO:  uuid =3D a1942895-bdb4-484a-a3fd-6b90e7652d8c
INFO:  uuid =3D f2b4a00f-52a0-4a63-aac0-0500b9e6d438
INFO:  uuid =3D f2b4a00f-52a0-4a63-aac0-0500b9e6d438
INFO:  uuid =3D c6607966-0685-4d09-87f5-c593f3dd8924
INFO:  uuid =3D b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid =3D b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid =3D b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid =3D b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid =3D b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid =3D b52c719e-6484-49e6-87db-d885d45d7313
 test_uuid
-----------

(1 row)

Regards

Eric


-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
Sent: Thursday, August 21, 2008 8:03 PM
To: Bruce Momjian
Cc: Eric P. Melbardis; Nicolas ANTONINI; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values

Hi.

Yes, Finally Ralf-san adjusts this patch.
http://winpg.jp/~saito/pg_work/OSSP_win32/.
Therefore, it is contained in the next release.(1.6.3/4)

Thanks!!

Regards,
Hiroshi Saito

----- Original Message -----
From: "Bruce Momjian" <bruce@momjian.us>


> Hiroshi Saito wrote:
>> Hi.
>>
>> This can obtain a comfortable result.
>> http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-2008=
0706.zip
>>
>> I will adjust with Rarf-san.
>
> Has this been completed?
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
Hi.

Ehh?..ugaa..sorry..
I made some mistakes, when it probably worked.
Please try this.(The date of a binary is 7/8)
http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080823.zip
I will arrange thoroughly again.
Thanks!

Regards,
Hiroshi Saito

----- Original Message -----
From: "Eric P. Melbardis" <eric.melbardis@netkitsolutions.com>


Hi

I downloaded the latest version from the specified url.
Put dll in the postgres "C:\Program Files\PostgreSQL\8.3\lib" directory, and restarted
postgres service


Sorry, still does not work!

nkworks3=# SELECT test_uuid(10);
INFO:  uuid = a1942895-bdb4-484a-a3fd-6b90e7652d8c
INFO:  uuid = f2b4a00f-52a0-4a63-aac0-0500b9e6d438
INFO:  uuid = f2b4a00f-52a0-4a63-aac0-0500b9e6d438
INFO:  uuid = c6607966-0685-4d09-87f5-c593f3dd8924
INFO:  uuid = b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid = b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid = b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid = b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid = b52c719e-6484-49e6-87db-d885d45d7313
INFO:  uuid = b52c719e-6484-49e6-87db-d885d45d7313
 test_uuid
-----------

(1 row)

Regards

Eric


-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
Sent: Thursday, August 21, 2008 8:03 PM
To: Bruce Momjian
Cc: Eric P. Melbardis; Nicolas ANTONINI; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values

Hi.

Yes, Finally Ralf-san adjusts this patch.
http://winpg.jp/~saito/pg_work/OSSP_win32/.
Therefore, it is contained in the next release.(1.6.3/4)

Thanks!!

Regards,
Hiroshi Saito

----- Original Message -----
From: "Bruce Momjian" <bruce@momjian.us>


> Hiroshi Saito wrote:
>> 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.
>
> Has this been completed?
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
Hi.

----- Original Message -----
From: "Bruce Momjian" <bruce@momjian.us>
> Hiroshi Saito wrote:
>> Hi.
>>
>> Yes, Finally Ralf-san adjusts this patch.
>> http://winpg.jp/~saito/pg_work/OSSP_win32/.
>> Therefore, it is contained in the next release.(1.6.3/4)
>
> OK, good.  Does any of this get applied to contrib/uuid-ossp?

There is nothing, uuid-ossp has an official release place. It will evolve uniquely.
Ralf-san supplies a great module to us.!:-)
As for try-uuidwin32 (native-uuid of winapi), it  is not suitable to contrib.
However, It may be pgfoundry supposing it is desired.

Thanks!

Regards,
Hiroshi Saito

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
Ooops, Please wait for this.

> Please try this.(The date of a binary is 7/8)
> http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080823.zip
> I will arrange thoroughly again.

Anyhow, I have only now stale development environment.
The time of a check is still required. thanks.

Regards,
Hiroshi Saito

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
Hi Eric-san.

Done! please check it.
http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080824.zip
I checked by the following machine.
-- Disktop(Windows-XP SP2)
Pentium(R) 4 CPU 2.6GHz
Memory 2GB
-- Notebook(Windows-XP SP2)
Pentium III CPU 495 MHz
Memory 256MB
--

Thanks.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>


> Ooops, Please wait for this.
>
>> Please try this.(The date of a binary is 7/8)
>> http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080823.zip
>> I will arrange thoroughly again.
>
> Anyhow, I have only now stale development environment.
> The time of a check is still required. thanks.
>
> Regards,
> Hiroshi Saito
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #4274: uuid returns duplicate values

From
"Hiroshi Saito"
Date:
Hi Eric-san.

Thank you for an early check. !
I understand that many users think are same with you.
more gratitude:-)

Regards,
Hiroshi Saito

----- Original Message -----
From: "Eric P. Melbardis" <eric.melbardis@netkitsolutions.com>


Hi

Testing on my home system, looking good... will try on my office system Monday.

Note:
        I am assuming that the uuid will mostly be used as a primary key on records that
will exist in replicated databases to guarantee uniqueness. The problem that is see with the
current uuid functions for this purpose is that the generated uuid is very random causing
great performance issues with the index; at least when using oracle and ms sql server, did
not try with postgres, but must be similar. Usually inserting random data into an index of
any kind is a worst case stress test. Hence the older style of uuid, based on mac addresses
and time tend to generate more sequential uuid's, at least when inserting a bunch of records
at once.

In other words it would be nice to have the old fashioned style of uuid's.

Regards

Eric


-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
Sent: Saturday, August 23, 2008 8:26 AM
To: Eric P. Melbardis; Bruce Momjian
Cc: Nicolas ANTONINI; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values

Hi Eric-san.

Done! please check it.
http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080824.zip
I checked by the following machine.
-- Disktop(Windows-XP SP2)
Pentium(R) 4 CPU 2.6GHz
Memory 2GB
-- Notebook(Windows-XP SP2)
Pentium III CPU 495 MHz
Memory 256MB
--

Thanks.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>


> Ooops, Please wait for this.
>
>> Please try this.(The date of a binary is 7/8)
>> http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-20080823.zip
>> I will arrange thoroughly again.
>
> Anyhow, I have only now stale development environment.
> The time of a check is still required. thanks.
>
> Regards,
> Hiroshi Saito
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #4274: uuid returns duplicate values

From
"Eric P. Melbardis"
Date:
Hi

Testing on my home system, looking good... will try on my office system Mon=
day.

Note:
        I am assuming that the uuid will mostly be used as a primary key on=
 records that will exist in replicated databases to guarantee uniqueness. T=
he problem that is see with the current uuid functions for this purpose is =
that the generated uuid is very random causing great performance issues wit=
h the index; at least when using oracle and ms sql server, did not try with=
 postgres, but must be similar. Usually inserting random data into an index=
 of any kind is a worst case stress test. Hence the older style of uuid, ba=
sed on mac addresses and time tend to generate more sequential uuid's, at l=
east when inserting a bunch of records at once.

In other words it would be nice to have the old fashioned style of uuid's.

Regards

Eric


-----Original Message-----
From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
Sent: Saturday, August 23, 2008 8:26 AM
To: Eric P. Melbardis; Bruce Momjian
Cc: Nicolas ANTONINI; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4274: uuid returns duplicate values

Hi Eric-san.

Done! please check it.
http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-2008082=
4.zip
I checked by the following machine.
-- Disktop(Windows-XP SP2)
Pentium(R) 4 CPU 2.6GHz
Memory 2GB
-- Notebook(Windows-XP SP2)
Pentium III CPU 495 MHz
Memory 256MB
--

Thanks.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Hiroshi Saito" <z-saito@guitar.ocn.ne.jp>


> Ooops, Please wait for this.
>
>> Please try this.(The date of a binary is 7/8)
>> http://winpg.jp/~saito/pg_work/OSSP_win32/pg8.3.3-win-bin-uuid-ossp-2008=
0823.zip
>> I will arrange thoroughly again.
>
> Anyhow, I have only now stale development environment.
> The time of a check is still required. thanks.
>
> Regards,
> Hiroshi Saito
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #4274: uuid returns duplicate values

From
tomas@tuxteam.de
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Aug 23, 2008 at 10:07:58AM -0700, Eric P. Melbardis wrote:
> Hi
>
> Testing on my home system, looking good... will try on my office system Monday.
>
> Note:
>         I am assuming that the uuid will mostly be used as a primary
> key on records that will exist in replicated databases to guarantee
> uniqueness. The problem that is see with the current uuid functions
> for this purpose is that the generated uuid is very random causing
> great performance issues with the index [...]
>                   Hence the older style of uuid, based on mac
> addresses and time tend to generate more sequential uuid's,
> at least when inserting a bunch of records at once.
>
> In other words it would be nice to have the old fashioned style of uuid's.

Note that in the days of virtual machines, those more or less "invent"
their MACs. Since they just have to be unique in the subnet (or
"broadcast domain"), collisions on a more global scale will go
unnoticed. But they might bite you in a replicated database scenario.

I wouldn't trust "old fashioned uuids" anymore.

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIsRk8Bcgs9XrR2kYRAkX6AJ9EoGka6NZ8dGijynYr/ujogStqfgCdEhU6
b1yyo+YNpmeqJ2IRMqowMHE=
=iZHA
-----END PGP SIGNATURE-----

Re: BUG #4274: uuid returns duplicate values

From
"Harald Armin Massa"
Date:
> I wouldn't trust "old fashioned uuids" anymore.
>

BTW: Windows has an integrated GUID creator. Used for a lot of things.
Used in all windows installations. THAT one should be fairly robust,
shouldn't it?

Would it be possible to have something like

ifdef win32
guid=3Dwindows-system-call-to-createguid()

??

Harald


--=20
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Stra=DFe 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!

Re: BUG #4274: uuid returns duplicate values

From
Tom Lane
Date:
"Harald Armin Massa" <haraldarminmassa@gmail.com> writes:
>> I wouldn't trust "old fashioned uuids" anymore.

> BTW: Windows has an integrated GUID creator. Used for a lot of things.
> Used in all windows installations. THAT one should be fairly robust,
> shouldn't it?

[ you just made me spill coffee all over my keyboard... ]  It's never
a good idea to use "Windows" and "robust" in the same sentence.

Try googling for "windows duplicate guids" and similar phrases.
I get 226000 hits on that one.

            regards, tom lane