pg*.dll and *.pdb files in psqlODBC have no version numbers

[Mark Hill]

I posted this question to 
pgsql-gene...@lists.postgrsql.org 
last week but on one has responded so posting here now.

We download the ODBC source from 
http://ftp.postgresql.org and build it on-site, 
13.02. in this case.

A colleague noticed that the following files in the psqlODBC MSI for Windows 
have no version numbers:
pgenlist.dll
pgenlista.dll
pgxalib.dll
pgenlist.pdb
pgenlista.pdb
psqlodbc30a.pdb
psqlodbc35w.pdb

Does anyone know if that is be design or some other reason?   Should they have 
version numbers?

I checked earlier build and the same holds for ODBC 12.02..
Thanks, Mark

CVE's addressed in next update

[Mark Hill]

Do we know, is it posted anywhere on the postgresql.org site what CVE's will be 
addressed in the next round up updates
to Postgres which should come out next Thursday, May 9th, 2024?

Thanks, Mark

ODBC Source Downloads Missing

[Mark Hill]

Is there an issue with the ODBC Source downloads today?

The source download URL isn't working:  
https://www.postgresql.org/ftp/odbc/versions/src/

Thanks, Mark

RE: ODBC Source Downloads Missing

[Mark Hill]

Thanks All!

From: Kashif Zeeshan 
Sent: Tuesday, June 11, 2024 7:55 AM
To: Fahar Abbas 
Cc: Mark Hill ; pgsql-hackers@lists.postgresql.org
Subject: Re: ODBC Source Downloads Missing


EXTERNAL


On Tue, Jun 11, 2024 at 4:52 PM Fahar Abbas 
mailto:syed.fahar.ab...@gmail.com>> wrote:
Hello Mark,

You can found psqlodbc on Link below

https://www.postgresql.org/ftp/odbc/releases/REL-16_00_0005/<https://protect.checkpoint.com/v2/___https://www.postgresql.org/ftp/odbc/releases/REL-16_00_0005/___.YzJ1OnNhc2luc3RpdHV0ZTpjOm86NmIwNTRiY2I0NGNhNjAzZDRjZDFmNDg0YjVhZjNmNDA6Njo3ODJhOmRmOTY5ODM1MjgyMDBhYTcxOGJjYjk5YTdhMTcwZjdjZTIyNGVkZjEzNGNjMzYxYjgxOGZjYzY4ZjhiNGM3Y2Q6aDpU>

He is talking about Source code whereas this link contains installer.

Regards
Kashif Zeeshan
Bitnine Global
Kind Regards,
Fahar Abbas

On Tuesday, June 11, 2024, Mark Hill 
mailto:mark.h...@sas.com>> wrote:
Is there an issue with the ODBC Source downloads today?

The source download URL isn’t working:  
https://www.postgresql.org/ftp/odbc/versions/src/<https://protect.checkpoint.com/v2/___https://www.postgresql.org/ftp/odbc/versions/src/___.YzJ1OnNhc2luc3RpdHV0ZTpjOm86NmIwNTRiY2I0NGNhNjAzZDRjZDFmNDg0YjVhZjNmNDA6Njo1NGExOjQ5OTcyMWZmZGUwZmUzODYxOThhYzU2YWM5ZDRlMTA5ODFlZDNjODMxZjAwOTMyYWIxNjM3NWNjZDk4ZWVmNjU6aDpU>

Thanks, Mark

FW: uuid-ossp source or binaries for Windows

[Mark Hill]

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 /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  
Sent: Wednesday, March 15, 2023 11:15 PM
To: 'Daniel Gustafsson' 
Cc: pgsql-gene...@lists.postgresql.org; Ken Peressini ; 
Michael King 
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 
"/share/extension/uuid-ossp.control"

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

I should have in addition:
/include/uuid.h
/lib/uuid-ossp.dll
/share/extension/uuid-ossp--1.1.sql
/share/extension/uuid-ossp.control
/share/extension/uuid-ossp--unpackaged--1.0.sql
/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 
Sent: Wednesday, March 15, 2023 3:16 PM
To: Mark Hill 
Cc: pgsql-gene...@lists.postgresql.org; Ken Peressini ; 
Michael King 
Subject: Re: uuid-ossp source or binaries for Windows

EXTERNAL

> On 15 Mar 2023, at 19:31, Mark Hill  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