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

From: "nicoanto" <na(at)mnm-consulting(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Date: 2008-05-14 14:40:18
Message-ID: 200805141440.m4EEeIrV022444@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4167
Logged by: nicoanto
Email address: na(at)mnm-consulting(dot)com
PostgreSQL version: 8.3.1.0
Operating system: Windows
Description: When generating UUID using UUID-OSSP module, UUIDs are
not unique on Windows
Details:

Hi all,

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 ?

Regards,

Nicoanto

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Wojciech Strzałka 2008-05-14 14:45:53 Problem with TOAST tables when removing TOASTable column
Previous Message Tom Lane 2008-05-14 14:34:09 Re: BUG #4166: Alter table add column from PgAdminIII