Re: How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

Hi MauMau-san

it my bug patch applied to ver 1.6.2....sorry..
then, I made the next patch is there, please see,
http://winpg.jp/~saito/pg_work/OSSP_win32/

I will be adjusted and Ralf-san again.

best regards,
Hiroshi Saito

(2013/10/30 21:45), MauMau wrote:
> Hello,
> 
> # Sorry, Saito san' address doesn't seem to exist, so excuse for sending
> again
> 
> For a certain reason, I need to build PostgreSQL on Windows with OSSP
> UUID support to use UUID for primary keys.  I have to use Visual Studio
> 2010.
> 
> The original source code for OSSP UUID and its fork for Windows can be
> downloaded from:
> 
> http://www.ossp.org/pkg/lib/uuid/
> http://sourceforge.jp/projects/sfnet_osspuuidwin32/
> 
> I built the latest version 1.6.2 and used uuid_generate_v4() as the
> default value for a primary key column of type uuid.  However, when I
> insert 200-300 rows, an unique constraint violation error is reported. 
> It occurs repeatedly in several retries.
> 
> I found some people hit the same problem in the past, but they didn't
> seem to get the solution:
> 
> http://www.postgresql.org/message-id/039e01c8b63c$d0c95e90$60096cdb@IBMC9A0F63B40D
> 
> http://www.postgresql.org/message-id/018d01c8dec6$2a14b470$0b01a8c0@IBMC9A0F63B40D
> 
> http://www.postgresql.org/message-id/98B20744191F464DB598A25AB00BC125@acer08f817a9b5
> 
> 
> When I copy lib\uuid_ossp.dll in the PostgreSQL community package, which
> I guess Dave Page san maintains, to my installation, the error does not
> occur. So, OSSP UUID library is the cause.
> 
> Saito san published a patch for OSSP UUID on his site:
> 
> http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/
> 
> And Dave san showed interest in it:
> 
> http://www.postgresql.org/message-id/SNT127-W18C42125E5FD719BA514CEFF1F0@phx.gbl
> 
> 
> How can I build the OSSP UUID library that functions properly on
> Windows? Is OSSP UUID 1.6.2 + Saito-san's patch the exact source for the
> uuid-ossp.dll in thecommunity binary?
> 
> 
> Regards
> MauMau
> 
> 
>