Re: FW: make rows unique across db's without UUIP on windows?

Hi Kimball-san

Thanks,

This problem concentrated the discussions by the reason
with not pgsql but uuid-ossp.

Certainly, I think that uuid is effective and the best for the deflecting solution.

Regards,
Hiroshi Saito

>Hiroshi,
>
>Thank you very much. I will look forward to it.
>
>However, I really wanted to know what PGSQL people are doing now and have
>done in the past to address this kind of issue.
>
>Surely the need to have unique rows across databases has come up before?
>
>Thanks,
>
>Kimball
>
>-----Original Message-----
>From: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp]
>Sent: Monday, June 02, 2008 8:46 PM
>To: kjohnson(at)voiceandnetworksystems(dot)com
>Cc: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] FW: make rows unique across db's without UUIP on
>windows?
>
>Hi.
>
>Ahh,yes.
>Patch is inspected for me now.
>Please wait for a while.
>
>Regards,
>Hiroshi Saito
>
>>From: Kimball Johnson [mailto:kimballjohnson(at)sbcglobal(dot)net]
>>Sent: Monday, June 02, 2008 7:42 PM
>>To: 'pgsql-general(at)postgresql(dot)org'
>>Subject: make rows unique across db's without UUIP on windows?
>>
>>
>>
>>Considering the discussions on the pgsql-bugs user list regarding
>ossp-uuip:
>>Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not
>>unique on Windows,
>>
>>
>>
>>What is the normal solution in pgsql-land for making a serious number of
>>rows unique across multiple databases?
>>
>>
>>
>>I mean particularly databases of different types (every type) used at
>>various places (everywhere) on all platforms (even MS[TM])? You know. a
>>UNIVERSAL id?
>>
>>
>>
>>I gotta have it! I'm doing distributed list management.
>>
>>
>>
>>Anyone got a real good, dependable, easy, and universally manageable
>>solution?
>>
>>
>>
>>Thanks,
>>
>>
>>
>>Kimball Johnson
>>