RE: uuid-ossp source or binaries for Windows

Hey Daniel,

Thanks for getting back to me.

I think the issue I'm having is that my build of Postgres is missing uuid pieces needed by our users.

They're executing the command:   CREATE EXTENSION "uuid-ossp"

and getting the error

ERROR:  could not open extension control file "<Postgres-Install-Home>/share/extension/uuid-ossp.control"

The only file matching "*uuid*" in my build of Postgres is:   <Postgres-Install-Home>/include/server/utils/uuid.h

I should have in addition:
<Postgres-Install-Home>/include/uuid.h
<Postgres-Install-Home>/lib/uuid-ossp.dll
<Postgres-Install-Home>/share/extension/uuid-ossp--1.1.sql
<Postgres-Install-Home>/share/extension/uuid-ossp.control
<Postgres-Install-Home>/share/extension/uuid-ossp--unpackaged--1.0.sql
<Postgres-Install-Home>/share/extension/uuid-ossp--1.0--1.1.sql

I need a Windows-specific install of uuid-ossp for the Postgres build to use, for both 32bit and 64bit Windows.

Thanks, Mark

-----Original Message-----
From: Daniel Gustafsson <daniel@yesql.se>
Sent: Wednesday, March 15, 2023 3:16 PM
To: Mark Hill <Mark.Hill@sas.com>
Cc: pgsql-general@lists.postgresql.org; Ken Peressini <Ken.Peressini@sas.com>; Michael King <Michael.King@sas.com>
Subject: Re: uuid-ossp source or binaries for Windows

EXTERNAL

> On 15 Mar 2023, at 19:31, Mark Hill <Mark.Hill@sas.com> wrote:
>
> I've downloaded the PostgreSQL 14.7 source and building it on Windows 64bit and 32bit.
>
> I'm using the Visual Studio tools in the src/tools/msvc folder.
>
> I'm trying to build with the uuid extension but it looks like I need
> uuid-ossp installed in order to get it to work.

Do you need the extension specifically or does the built-in generator function do what you need?

> The source download referenced in the Postgresql doc here,
> https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.
> postgresql.org%2Fdocs%2Fcurrent%2Fuuid-ossp.html%23id-1.11.7.58.6&data
> =05%7C01%7CMark.Hill%40sas.com%7C5acf51786dd5440ea0ed08db2589a9fd%7Cb1
> c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145045990073139%7CUnknown%
> 7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJX
> VCI6Mn0%3D%7C3000%7C%7C%7C&sdata=TSRqdrvImMLf6Pr8XWqRSUkCWUDaAjFtziykz
> Czt5Sc%3D&reserved=0 this source download,
>
https://nam02.safelinks.protection.outlook.com/?url=ftp%3A%2F%2Fftp.ossp.org%2Fpkg%2Flib%2Fuuid%2Fuuid-1.6.2.tar.gz&data=05%7C01%7CMark.Hill%40sas.com%7C5acf51786dd5440ea0ed08db2589a9fd%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145045990073139%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ry3iJshaFPSegaIrmaJzA0%2BIKgEfXbJwmasBA8ZdWQ8%3D&reserved=0,
isUnix-specific as far as I can tell. 
>
> Where can I find uuid-ossp for Windows, 32 and 64 bit, either the
> source so I can build it or prebuilt libraries?

I don't know windows at all, but uuid-ossp.dll is provided in the EDB packages (looking at the binary zip bundle) so
it'sclearly available to be built. 
Maybe someone from EDB can chime in with pointers for building on Windows so we can update the docs accordingly?

--
Daniel Gustafsson