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

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: <pgsql-bugs(at)postgresql(dot)org>
Cc: "Ismael Ciordia, Openbravo" <ismael(dot)ciordia(at)openbravo(dot)com>
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Date: 2008-11-12 16:07:26
Message-ID: 91DEB81C61374C35BE7A7EF05F2CE29C@HIRO57887DE653
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Faithful record-keeping this ML(pgsql-bug).

Fixed the bug in both Windows and Ubuntu platforms.
It is uuid-ossp version 1.6.2.

Thanks!

Regards,
Hiroshi Saito

----- Original Message -----
From: "Ismael Ciordia, Openbravo" <ismael(dot)ciordia(at)openbravo(dot)com>
Subject: RE: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on
Windows

> Sure, no problem.
>
> Thanks again
>
> -----Mensaje original-----
> De: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp]
> Enviado el: miércoles, 12 de noviembre de 2008 16:37
> Para: Ismael Ciordia, Openbravo
> Asunto: Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP
> module, UUIDs are not unique on Windows
>
>
> Hi Ismael-san.
>
> No problem.
> good news will be comfortable.:-)
>
> P.S)
> May I act to pgsql-bug-ML as the forward of this report?
>
> Regards,
> Hiroshi Saito
>
> ----- Original Message -----
> From: "Ismael Ciordia, Openbravo" <ismael(dot)ciordia(at)openbravo(dot)com>
> To: "'Hiroshi Saito'" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
> Sent: Thursday, November 13, 2008 12:26 AM
> Subject: RE: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module,
> UUIDs are not unique on
> Windows
>
>
>> Hi Hiroshi-san,
>>
>> we have tested the problem in an Ubuntu box and it works perfectly. Sorry
>> for inconveniences, and thanks a lot for your support.
>>
>> Kind regards,
>>
>> Ismael
>>
>> -----Mensaje original-----
>> De: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp]
>> Enviado el: miércoles, 12 de noviembre de 2008 10:05
>> Para: Ismael Ciordia, Openbravo
>> Asunto: Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP
>> module, UUIDs are not unique on Windows
>>
>>
>> Hi Ismael-san.
>>
>> Is passing this problem information to pgsql-bug-ML allowed?
>> I think that this Ubuntu problem is suitable as shared information.
>>
>> Regards,
>> Hiroshi Saito
>>
>> ----- Original Message -----
>> From: "Ismael Ciordia, Openbravo" <ismael(dot)ciordia(at)openbravo(dot)com>
>> To: "'Hiroshi Saito'" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
>> Sent: Wednesday, November 12, 2008 5:35 PM
>> Subject: RE: [BUGS] BUG #4167: When generating UUID using UUID-OSSP
> module,
>> UUIDs are not unique on
>> Windows
>>
>>
>>> Thanks a lot, Hiroshi-san. You have been very helpful. I will
> double-check
>>> the problem in Ubuntu.
>>>
>>> Regards,
>>>
>>> Ismael
>>>
>>> -----Mensaje original-----
>>> De: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp]
>>> Enviado el: miércoles, 12 de noviembre de 2008 2:23
>>> Para: Ismael Ciordia, Openbravo
>>> Asunto: Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP
>>> module, UUIDs are not unique on Windows
>>>
>>>
>>> Hi Ismael-san.
>>>
>>> The windows environment has already realized by special correction.
>>> Then, they are Ralf-san with me check ending and become 1.6.3/4
> following.
>>> http://winpg.jp/~saito/pg_work/OSSP_win32/
>>> Furthermore, the fixed version is built in pginstaller (8.3.5).
>>>
>>> However, It is not the Ubuntu environment........
>>> It may have the own problem of Ubuntu.
>>>
>>> Regards,
>>> Hiroshi Saito
>>>
>>> ----- Original Message -----
>>> From: "Ismael Ciordia, Openbravo" <ismael(dot)ciordia(at)openbravo(dot)com>
>>>
>>>
>>>> Hi Hiroshi-san,
>>>>
>>>> we are interested in fixing the bug in both Windows and Ubuntu
> platforms.
>>>>
>>>> It is not clear to me yet where the fix should be done (in the UUID-OSSP
>>>> module or at Operative System level). I would like to get in contact
> with
>>>> someone who could fix it in both platforms and guarantee that the fix
>> will
>>>> be included in the next PostgreSql public release to discuss with him
> how
>>> we
>>>> can sponsor the development.
>>>>
>>>> Is Ralf this person? If yes, how I could reach him? If not possible, is
>>>> there any other person who could do it?
>>>>
>>>> Thanks in advance for your help. Regards,
>>>>
>>>> Ismael
>>>>
>>>> -----Mensaje original-----
>>>> De: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp]
>>>> Enviado el: martes, 11 de noviembre de 2008 15:58
>>>> Para: Ismael Ciordia, Openbravo
>>>> Asunto: Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP
>>>> module, UUIDs are not unique on Windows
>>>>
>>>>
>>>> Hi Ismael-san.
>>>>
>>>> ----- Original Message -----
>>>> From: "Ismael Ciordia, Openbravo" <ismael(dot)ciordia(at)openbravo(dot)com>
>>>>
>>>>
>>>>> Hi Hiroshi,
>>>>>
>>>>> this is Ismael Ciordia from Openbravo. In the next release of Openbravo
>>>> ERP
>>>>> (2.50) we are doing extensive use of UUID. Is there any progress on
> this
>>>>> bug? We have experienced as well this bug in a linux (Ubuntu)
>>> environment,
>>>>> do you know if it is reported?
>>>>
>>>> It seems that some Ubuntu users are looking at the problem to be sure.
>>>> Probably, Ralf-san(OSSP project leader) is very busy now....
>>>>
>>>>>
>>>>> We have prepared an ugly work around to solve it (do a loop till
>>> generated
>>>>> ID changes from the last execution) but it is not gonna work in
>>> production
>>>>> environments.
>>>>>
>>>>> We are really interested in a fix to this bug included in the next
>>>>> PostgreSql release, and we would consider to sponsor this development
> if
>>>>> required.
>>>>
>>>> Ahh, sorry.. I don't have the environment of Ubuntu now.
>>>> My usual environment is win32, FreeBSD, and OpenSUSE.
>>>>
>>>
>>
>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-11-12 16:09:21 Re: BUG #4523: TO_CHAR function : the ".US" format returns incorrect value
Previous Message Moussard 2008-11-12 15:11:59 BUG #4523: TO_CHAR function : the ".US" format returns incorrect value