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
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:
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:
And Dave san showed interest in it:
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?
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: