Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Bugs > BUG #4167: When...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 3768 of 4180
Post > Topic >>

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

by na@[EMAIL PROTECTED] ("nicoanto") May 14, 2008 at 02:40 PM

The following bug has been logged online:

Bug reference:      4167
Logged by:          nicoanto
Email address:      na@[EMAIL PROTECTED]
 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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
 




 8 Posts in Topic:
BUG #4167: When generating UUID using UUID-OSSP module, UUIDs ar
na@[EMAIL PROTECTED] (&q  2008-05-14 14:40:18 
Re: BUG #4167: When generating UUID using UUID-OSSP module, UUID
peter_e@[EMAIL PROTECTED]  2008-05-14 17:34:49 
Re: BUG #4167: When generating UUID using UUID-OSSP module,
alvherre@[EMAIL PROTECTED  2008-05-14 11:44:42 
Re: BUG #4167: When generating UUID using UUID-OSSP module, UUID
peter_e@[EMAIL PROTECTED]  2008-05-14 17:57:43 
Re: BUG #4167: When generating UUID using UUID-OSSP module, UUID
tgl@[EMAIL PROTECTED] (T  2008-05-14 12:14:20 
Re: BUG #4167: When generating UUID using UUID-OSSP module,
nicolas.antonini@[EMAIL P  2008-07-03 15:03:48 
Re: BUG #4167: When generating UUID using UUID-OSSP module, UUID
z-saito@[EMAIL PROTECTED]  2008-07-04 02:26:14 
Re: BUG #4167: When generating UUID using UUID-OSSP module, UUID
heikki@[EMAIL PROTECTED]   2008-05-14 16:45:41 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 11:10:58 CST 2008.