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

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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Cc: "nicoanto" <na(at)mnm-consulting(dot)com>
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Date: 2008-05-14 15:34:49
Message-ID: 200805141734.51653.peter_e@gmx.net (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-bugs
Am Mittwoch, 14. Mai 2008 schrieb nicoanto:
> I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on
> order to generate UUID values using the UUID-OSSP module
> The code of the function is the following one :
>
>     CREATE FUNCTION uuidgen() RETURNS CHAR(36) AS $$
>        BEGIN
>           RETURN uuid_generate_v4()::CHAR(36);
>        END;
>     $$ LANGUAGE 'plpgsql';
>
>
>
> When using it in a loop, I have got 2 different behaviors :
> * on an Ubuntu platform, the generated UUID values are unique
> * on a Windows platform, the generated UUID values are not unique most of
> the time.
>
> Do you have any idea on how to fix that bug on a Windows platform ?

Congratulations, you have just independently rediscovered the Debian OpenSSL 
vulnerability, see http://www.debian.org/security/2008/dsa-1571.  Get a new 
libssl package from the Ubuntu security repository.  It's not a Windows bug; 
the numbers are supposed to be different.

In response to

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2008-05-14 15:44:42
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module,UUIDs are not unique on Windows
Previous:From: Wojciech StrzałkaDate: 2008-05-14 15:21:05
Subject: Re: Problem with TOAST tables when removing TOASTable column

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