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@xxxxxxxxxxxxxxxx] >Sent: Monday, June 02, 2008 8:46 PM >To: kjohnson@xxxxxxxxxxxxxxxxxxxxxxxxxx >Cc: pgsql-general@xxxxxxxxxxxxxx >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@xxxxxxxxxxxxx] >>Sent: Monday, June 02, 2008 7:42 PM >>To: 'pgsql-general@xxxxxxxxxxxxxx' >>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 >>
