FW: uuid-ossp source or binaries for Windows

From: Mark Hill <Mark(dot)Hill(at)sas(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: FW: uuid-ossp source or binaries for Windows
Date: 2023-03-16 13:31:03
Message-ID: BN8PR05MB66578CC724A7F8ED62E981B2EEBC9@BN8PR05MB6657.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I posted this to pgsql-general but I think that's more for Postgres users. I'm trying to build Postgres
with the uuid-ossp extension on Windows using the msvc toolset provided with the Postgres source
in <postgresSourceHome>/src/tools/msvc, e.g. postgresql-14.7/src/tools/msvc.

I think I need uuid-ossp installed. The uuid-ossp source located here: ftp://ftp.ossp.org/pkg/lib/uuid/uuid-1.6.2.tar.gz
is Unix-specific.

Is there uuid-ossp source download for Windows or are uuid-ossp prebuilt binaries for Windows available?

Thanks, Mark

-----Original Message-----
From: Mark Hill <Mark(dot)Hill(at)sas(dot)com>
Sent: Wednesday, March 15, 2023 11:15 PM
To: 'Daniel Gustafsson' <daniel(at)yesql(dot)se>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org; Ken Peressini <Ken(dot)Peressini(at)sas(dot)com>; Michael King <Michael(dot)King(at)sas(dot)com>
Subject: RE: uuid-ossp source or binaries for Windows

EXTERNAL

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(at)yesql(dot)se>
Sent: Wednesday, March 15, 2023 3:16 PM
To: Mark Hill <Mark(dot)Hill(at)sas(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org; Ken Peressini <Ken(dot)Peressini(at)sas(dot)com>; Michael King <Michael(dot)King(at)sas(dot)com>
Subject: Re: uuid-ossp source or binaries for Windows

EXTERNAL

> On 15 Mar 2023, at 19:31, Mark Hill <Mark(dot)Hill(at)sas(dot)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%2F&data=05%7C01%7Cmark.hill%40sas.com%7C2fe3e6f033eb4de4506708db25cca633%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145333114215621%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4dfMYruL3rZjCY8ScPUM70xOk%2FM2WJIs8FPw4xXrUI0%3D&reserved=0.
> 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%7C2fe3e6f033eb4de4506708db25cca633%7Cb1c14d5c362545b3a4309552373a0c2f%7C0%7C0%7C638145333114215621%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=t9AVwe32CRgcW9oH%2Fmjj0lC8SSIAw0cBrQXmH1GKcNc%3D&reserved=0, is Unix-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's clearly 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dávid Suchan 2023-03-16 14:56:48 Re: pg_upgrade Only the install user can be defined in the new cluster
Previous Message Dolan, Sean 2023-03-16 13:20:57 RE: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows!

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2023-03-16 13:40:04 gcc 13 warnings
Previous Message Melih Mutlu 2023-03-16 13:29:12 Re: Allow logical replication to copy tables in binary format