Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

Hi.

Sorry,very late reaction...

Thanks!, It's a good information.:-)
and,CC to Ralf-san.

Regards,
Hiroshi Saito

>Hi Hiroshi-san,
>
>we have run our test in the next environments:
>-Windows XP + PostgreSql 8.3.5
>-Ubunto + PostgreSql 8.3.3
>
>In both cases the test was successful, so we have closed the topic.
>
>Thanks a lot for your support, PostgreSql is an incredible database.
>
>Kind regards,
>
>Ismael
>
>-----Mensaje original-----
>De: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp]
>Enviado el: mi駻coles, 12 de noviembre de 2008 17:15
>Para: pgsql-bugs(at)postgresql(dot)org
>CC: Ismael Ciordia, Openbravo
>Asunto: Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP
>module, UUIDs are not unique on Windows
>
>
>Ooops, It will be helpful to a user.
>Therefore, it transmits here.:-)
>Thanks!!
>
>-- copy --
>Hi Hiroshi-san,
>
>if you want you can include the function we have used to test the problem,
>pasted below.
>
>Regards,
>
>Ismael
>
>**************
>
>CREATE OR REPLACE FUNCTION test_uuidgen(countmax INTEGER) RETURNS character
>varying AS
>$BODY$
>DECLARE
> countmin INTEGER := 1;
> distinctuuid bigint;
> v_message VARCHAR(2000) := '';
>
>BEGIN
> drop table if exists uuid_gen;
> CREATE TABLE uuid_gen
> (
> uuid_gen_col uuid NOT NULL
>
> );
> LOOP
> INSERT INTO uuid_gen (uuid_gen_col) VALUES (uuid_generate_v1());
> countmin := countmin + 1;
> EXIT WHEN countmin > countmax;
> END LOOP;
> SELECT COUNT(DISTINCT uuid_gen_col) INTO distinctuuid FROM uuid_gen;
> IF distinctuuid <> countmax THEN
> v_message := 'Repeated UUID: FAILS';
> ELSE
> v_message := 'NO repeated UUID: OK';
> END IF;
> RETURN v_message;
>END;
>$BODY$ LANGUAGE 'plpgsql';