From: | "MauMau" <maumau307(at)gmail(dot)com> |
---|---|
To: | <dpage(at)postgresql(dot)org>, <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | How can I build OSSP UUID support on Windows to avoid duplicate UUIDs? |
Date: | 2013-10-30 12:42:36 |
Message-ID: | BE8F92AC60854B37BC7D1DDFF1E3E458@maumau |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2013-10-30 12:45:03 | Re: Something fishy happening on frogmouth |
Previous Message | Robert Haas | 2013-10-30 12:23:11 | Re: Something fishy happening on frogmouth |