From: | Mark Hill <Mark(dot)Hill(at)sas(dot)com> |
---|---|
To: | 'Daniel Gustafsson' <daniel(at)yesql(dot)se> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <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 |
Date: | 2023-03-16 03:14:46 |
Message-ID: | BN8PR05MB66576CABD99340433FD7686DEEBC9@BN8PR05MB6657.namprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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.
> 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, 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
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-03-16 05:45:24 | Re: "No Free extents", table using all allocated space but no rows! |
Previous Message | wangw.fnst@fujitsu.com | 2023-03-16 02:43:52 | RE: Support logical replication of DDLs |
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2023-03-16 03:24:51 | Re: Allow logical replication to copy tables in binary format |
Previous Message | Alexander Lakhin | 2023-03-16 03:00:00 | Re: windows CI failing PMSignalState->PMChildFlags[slot] == PM_CHILD_ASSIGNED |