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: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org, 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:44:42
Message-ID: 20080514154442.GJ5521@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Peter Eisentraut wrote:
> 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.

Hmm, surely the problem is unrelated?  He gets the same numbers on
_Windows_, whereas Ubuntu shows the good behavior.

Also, OOSP-UUID does not depend on OpenSSL AFAIR.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2008-05-14 15:45:41
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Previous:From: Peter EisentrautDate: 2008-05-14 15:34:49
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

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