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-w18c42125e5fd719ba514ceff...@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 > > > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
