Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qvyuW-008vge-1W for pgsql-odbc@arkaria.postgresql.org; Thu, 26 Oct 2023 11:52:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qvyuU-00GZ7P-6Y for pgsql-odbc@arkaria.postgresql.org; Thu, 26 Oct 2023 11:52:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qvyuT-00GZ7G-KK for pgsql-odbc@lists.postgresql.org; Thu, 26 Oct 2023 11:52:21 +0000 Received: from mail-vi1eur05on2121.outbound.protection.outlook.com ([40.107.21.121] helo=EUR05-VI1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qvyuP-002uyi-GU for pgsql-odbc@lists.postgresql.org; Thu, 26 Oct 2023 11:52:20 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ZvOmpd27EbFymjcnFddyd37RhNkW97Oud7Gpa1wXMeNEVLIBIvEkqbpM44BpgTJ2f4rkRKfRP7i5+xS6APjMDPajMBPDqq7GkcwwRaK7OhuLKGDa2xTuJATZV7XsJE+5r9rzqtN1VVBVd0amT/AjaQoHp+2YZGgZUrAS73rHNC5rtGCgs1xSp2Np/2BC9X0gb5FaHKcF6x7IpmTNii42DcumOVTeO7Cu42ScGhLuvQKEZRSXiGka9LHJcBr9WrVVyvy6ZO+iWOegH4NYXkfY+GyzL5nfh8w1UNiQm3qprz8ZFfpzkFwQ/qwNRmyYQ5Yamq11KkVkY0j+QrHvyADoBQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=OicRocOlLNbY+L2KbTKFWqV4++4P02gY8cu+drJqDfo=; b=S4esgsByWezJF+iX7MpsGa2xhzSVJwsAHg6rFGWOi9uNI5yUk4P0H6an0vN1Bqyx/yHifUBvwn3+0tHj1LHMhVpxAAUjKIYW1q0JldmPT9xRsqwMmADOAmPPAoV1IySAyDITfxi89o2OYgHt7M88C569SQqLJjQOH/l6GK9j0Mz8HzXUIO30ctHOBPz72BAL/9GS4oos4aD/F1Dls0mhM9FQ8yjVAqBZAKizQ+Y0+GdffbCBU/JFOcsJ3UlIrTO5CKAdsUt/YT71p+wy3nPS+DeAfsEojjNy5NjM6yBIACdNacYHs8Ntkx19WP9wSmeWfMELDBr6enEOLAOSLY8ujg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=wur.nl; dmarc=pass action=none header.from=wur.nl; dkim=pass header.d=wur.nl; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wur.nl; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=OicRocOlLNbY+L2KbTKFWqV4++4P02gY8cu+drJqDfo=; b=o8muRw5/G1cZ0J53Oq3g/nZUNwnpGIw0mYu9WnpE2JER6HPcrgDSqOfr7u9e/9azj5d1ZK7a+GcSNivZQoNu9aj5/yeFLIQo36SKao5TYN48gufKV9tw/xqp7qmokRyTwJj/9YGTEevH6EdzlH17c11KvdJ81dWMrG0lCIDteW/CdMn7x5VzHUGFN4UjyCeSI8XsyznQ4pJ52+7K7Nwdk3ZTUag8PrlyUZnj+YP2SuWWy+XrgJZ6Q9AnDBBahWp0xJsdJ6Ao61URB0KErGXo92gRU1U7wniixw+MWiVLdD3o9vXEk4d62QnEFp0nHldHT946Qe2BLp8P32TDIJl00g== Received: from AM0PR01MB5634.eurprd01.prod.exchangelabs.com (2603:10a6:208:171::11) by AS8PR01MB8779.eurprd01.prod.exchangelabs.com (2603:10a6:20b:40e::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6933.22; Thu, 26 Oct 2023 11:52:11 +0000 Received: from AM0PR01MB5634.eurprd01.prod.exchangelabs.com ([fe80::b7be:ef00:1edc:15b1]) by AM0PR01MB5634.eurprd01.prod.exchangelabs.com ([fe80::b7be:ef00:1edc:15b1%7]) with mapi id 15.20.6933.019; Thu, 26 Oct 2023 11:52:11 +0000 From: "Wal, Jan Tjalling van der" To: Dave Cramer , Mark Hill CC: "pgsql-odbc@lists.postgresql.org" Subject: RE: pg*.dll and *.pdb files in psqlODBC have no version numbers Thread-Topic: pg*.dll and *.pdb files in psqlODBC have no version numbers Thread-Index: AdoHa9QRfHAcJBJHSqGyjdZyTyy87AAhiW0AAAPMvwA= Date: Thu, 26 Oct 2023 11:52:11 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US, en-NL Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=wur.nl; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AM0PR01MB5634:EE_|AS8PR01MB8779:EE_ x-ms-office365-filtering-correlation-id: f6d09102-d757-4320-ade4-08dbd619fd61 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: +0R9AaWQe/Xmpg9s/yahL5xqduQ+hZmntKOLBP7UMuiKZD6xSPsOA3a8XsjNwfiQ2ZIrtWQ722dz2hSoGVM1XU9sBvQsonIPLyaIe0Usp0jCex1p9ktkLhmKj4J6CNluOYfIXzhHxfIxiXNTHcTx+LAynzB6zPdl09OamQVR87p/2t/K9Md0APOBRCuX7Tbmr3xHNDvxX5HKLU9oY6kZ75YCdtGva0nHCQzGhGTluXJHNSXXRrUtLiuvhTT1O0X73nSO3+xYC5OFVFf3FbCOvh87rYAja45VOKw28Q3thFl3U/2FJTAo4UG/uU9KBP0pjD2VdjwgipJ8Z7RXHdzT+Lx0qZ6WGrqiHCsbFldJqzLKkxKLDEIl5Hfy7wlIHBv7E16yptudAC+rNeezpIgYPHG62MWJV7MrXCEPSxhN56zekZ+fkTeaqIvoeiFLiGrHWTpx/a32KpmeTweY4ZHvxnNpw1Iw414aGzk2TOCxCOIAhNz72NsGUyEtLio3/qbP51evpGARf6c5gxQf9JdwgH9ArdAXuETT+60nOkrT4+TQhkhYFU0/TlrH/n4vQoGm7txoTJgL2iYmCfqhgEe48zggChrvnmvCCEIzyK4TeDI= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM0PR01MB5634.eurprd01.prod.exchangelabs.com;PTR:;CAT:NONE;SFS:(13230031)(39860400002)(136003)(346002)(366004)(396003)(376002)(230922051799003)(186009)(64100799003)(1800799009)(451199024)(52536014)(9326002)(8936002)(8676002)(4326008)(786003)(41300700001)(478600001)(966005)(110136005)(83380400001)(166002)(2906002)(316002)(38070700009)(55016003)(5660300002)(66476007)(76116006)(66446008)(64756008)(66556008)(66946007)(33656002)(71200400001)(122000001)(38100700002)(6506007)(53546011)(7696005)(9686003)(26005)(86362001)(579004);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?DeXvnWms5DgUVgAWmvFJVYaqJjcwRpUgiwEjhR5KbJmCnKZPFOMdGS/OUC?= =?iso-8859-1?Q?up5029odWKhy7gYkQxYGy05ZEcxeWmy+7c2rea3ZJJRr1srQxy6n7gfDVm?= =?iso-8859-1?Q?+ZXqyzz++CBl3r7r9+ggI0HH7t/8JpcvQnHMm9WirkDFcR/cO2NlVEe2rb?= =?iso-8859-1?Q?OyiedLOVZ15IsYOUpaGQ2yq1oF/Qv+mX0lkWD0YI5pQSn0Gp64skrkzHst?= =?iso-8859-1?Q?VRFctTbr8Hlw32i6D54PEJIvk7rbHfuxOzTxlofzyKuTKW14G9uE2iEY45?= =?iso-8859-1?Q?HSrXUuTqy0v/SpuEuedWkUcaJkuiZukv8CfWQht921p04CIEd72E39muu0?= =?iso-8859-1?Q?vnNhaT1IfEigIOPCeKX5Yz90m24qb9ujs0GJRCqoZWJkDz1ZQl+CWnaTqJ?= =?iso-8859-1?Q?DagIOQhtmcD+bzpZrqVdNoVgH2XnNkexnYPHBU/rXQZryWJ9HJf/kOIBA0?= =?iso-8859-1?Q?Ea3smsOslB9rk9UqMG2zJyqTC0K8pHoWLP8cRKd+joj9BRk8sNMh5ddMCb?= =?iso-8859-1?Q?KabF6SGsjKut/KfEWTbifTvKl0FAbn/DEgaAU0pUakygOrkzSFuOan61u+?= =?iso-8859-1?Q?0Gz07PEYVg15am97F7AOzsPaoR20t/89lVUZnLBuNzkVO7LUdIyFvgjCfH?= =?iso-8859-1?Q?7hhfS1rW16QQU0cFvUdqu1zGSmH3m4wU9Nicbdq2KBC+oyqbhBO0gw+YhR?= =?iso-8859-1?Q?vY2pwviURn6YrpkZrHanCDponxUKPebhsOM8Fklp/QEPQ2XvAwcrnSp7v8?= =?iso-8859-1?Q?Yzaa6mCadUjGPlk1Y1FD6KoNDUcYVAhiJBJtdvhLxMcGcoZeWlg4JcGUxO?= =?iso-8859-1?Q?8dnuh6KuLSFbMWE4ug5sdb/7G5qJsG637BwmqhYt8aI5TWQ8bs3mtjW6tP?= =?iso-8859-1?Q?0cbgxQxjuZ2k9+2kJ41puigVISFYyjtjIfj88BKqpRv7Lrk/bcBNpBqI1C?= =?iso-8859-1?Q?6pTxc+O0VMSyTt0rFxzXdqgxf+HjTVYw24s5EQ73iDH5ZyWmhJGuKVAeZl?= =?iso-8859-1?Q?Iq3FPRlqeKa1lMOYslnp0p7ossNKbKG5iA6EIkym98y7QfcXbhs06HhV32?= =?iso-8859-1?Q?9Y5CuCd8Fm5uOmdMaroFcOYKBlFoXrPuBYeK31GVMLb/O+JK3Bjv2BffOd?= =?iso-8859-1?Q?PB08sCXMryONdMpZtTWKJbrLTnxg5hsdV2oWLB/rh5F/SETbnt/q7co0CV?= =?iso-8859-1?Q?IKp3qWwyOOwEV1IsmP4kdcU6OOtg0+9FarHKIm4xW811bFdW8LQoBzRpv3?= =?iso-8859-1?Q?IHLtLx71mHaS8JvF4pws86ExlVJT14KH+kqSX2KgQla7QhsyZ4mgKQvM6e?= =?iso-8859-1?Q?c5KHB5rbzaysPBeYiGH4nq+ND5E82nYnIjwvvZrW1UTQqLK3jGFpPZnLkh?= =?iso-8859-1?Q?I1pzmSeEWmkhyMpAseDjW+W06N1uCv/oIYIcscZB8+luxh2q7TuKCK7X1K?= =?iso-8859-1?Q?7ONBFYGBaNcWOPpW6LLmsfZY4aaCReOHajxzMcNISksW+dUX9vl9cuTDem?= =?iso-8859-1?Q?aN5aJtynQLMEWfgxDn3H/a4n5WyXjhnWKj/1DR85PCOqV8y30qJ5NSiNc3?= =?iso-8859-1?Q?Py9Goe+UIFLVE/f0iQF5Wdqu7C0IurHl1iSqx/gVUFYXQxVebTo6OdRg/R?= =?iso-8859-1?Q?7DFBpeOmNydBCrt1jM9hRPutxoAUOmdJumH/3YH0RupwclzIaeAoX6NA?= =?iso-8859-1?Q?=3D=3D?= Content-Type: multipart/alternative; boundary="_000_AM0PR01MB56342C5B3D7E85BC923DC53CDDDDAAM0PR01MB5634eurp_" MIME-Version: 1.0 X-OriginatorOrg: wur.nl X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AM0PR01MB5634.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-Network-Message-Id: f6d09102-d757-4320-ade4-08dbd619fd61 X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Oct 2023 11:52:11.6385 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 27d137e5-761f-4dc1-af88-d26430abb18f X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: w8uAOY3wPgV2y7SWLQTxcErg4ZNFvYMs5FbLWN2hFN01H4xr7nTXODVmjNDDSOzYF1IXreP7yoRRmFkc5+5yhMnjYH97A5n2J9CBx/bcTTA= X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS8PR01MB8779 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_AM0PR01MB56342C5B3D7E85BC923DC53CDDDDAAM0PR01MB5634eurp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello Dave, I cannot check for v13.02.00 anymore, but by the looks of it v15.00.00 has = the same. Name Extension Size Attributes Modified Version libcrypto-3-x64.dll dll 4,467,200 ---A-------- 20/06/2023 12:30 3.0.9.0 libpq.dll dll 308,736 ---A-------- 20/06/2023 12:58 15.0.3.23170 libssl-3-x64.dll dll 774,144 ---A-------- 20/06/2023 12:30 3.0.9.0 msvcp140.dll dll 627,992 ---A-------- 22/12/2021 23:34 14.16.27033.0 pgenlist.dll dll 29,696 ---A-------- 23/06/2023 16:23 pgenlist.pdb pdb 634,880 ---A-------- 23/06/2023 16:23 pgenlista.dll dll 29,696 ---A-------- 23/06/2023 16:23 pgenlista.pdb pdb 634,880 ---A-------- 23/06/2023 16:23 pgxalib.dll dll 35,328 ---A-------- 23/06/2023 16:23 psqlodbc30a.dll dll 572,416 ---A-------- 23/06/2023 16:23 15.0.0.0 psqlodbc30a.pdb pdb 1,904,640 ---A-------- 23/06/2023 16:23 psqlodbc35w.dll dll 586,752 ---A-------- 23/06/2023 16:23 15.0.0.0 psqlodbc35w.pdb pdb 1,945,600 ---A-------- 23/06/2023 16:23 vcruntime140.dll dll 85,784 ---A-------- 22/12/2021 23:34 14.16.27033.0 That can confirm that both older and newer versions consistently have no ve= rsion for some files. Which seems to be in line with the previous answer. All files shown here are in a subdir \psqlODBC\1500\bin. In a still existing .\1302\bin only two files remain: libcrypto-1_1-x64.dll= and libssl-1_1-x64.dll. So overwriting may not be what happens, but old version are removed/uninsta= lled and new dll are written along with the newer/matching driver installat= ion. I hope this adds something useful for you. Kind regards, Jan Tjalling van der Wal Wageningen Marine Reseach (WMR) / formerly IMARES Institute for Marine Re= sources & Ecosystem Studies Ankerpark 27, 1781 AG Den Helder Postbus 57, 1780 AB Den Helder Tel. +31 (0)317-4 87147 # GSM. +31 (0)626120915 (priv= =E9) # # Ma+Di Vr 09:00-18:00, Wo XX, Do+Vr 09:00-18:00 Jan_Tjalling.vanderWal@wur.nl From: Dave Cramer Sent: Thursday, October 26, 2023 11:51 AM To: Mark Hill Cc: pgsql-odbc@lists.postgresql.org Subject: Re: pg*.dll and *.pdb files in psqlODBC have no version numbers On Wed, 25 Oct 2023 at 13:53, Mark Hill > wrote: I posted these questions to this group a few weeks ago but haven't received= a response so reposting to see if anybody has any ideas. We download the ODBC source from http://ftp.postgresql.org and build it on-site, 13.02.0000 in= this case. A colleague noticed that the following files in the psqlODBC MSI for Window= s 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 hav= e version numbers? I checked earlier build and the same holds for ODBC 12.02.0000. Doesn't look like we have ever versioned them. My guess is that by not vers= ioning them when you install the latest it overwrites the existing Dave Thanks, Mark --_000_AM0PR01MB56342C5B3D7E85BC923DC53CDDDDAAM0PR01MB5634eurp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello Dave= ,

 = ;

I cannot c= heck for v13.02.00 anymore, but by the looks of it v15.00.00 has the same.<= o:p>

Name<= /o:p>

Extension<= o:p>

Size<= /o:p>

Attributes=

Modified

Version

libcrypto-= 3-x64.dll

dll

4,467,200<= o:p>

---A------= --

20/06/2023= 12:30

3.0.9.0

libpq.dll<= o:p>

dll

308,736

---A------= --

20/06/2023= 12:58

15.0.3.231= 70

libssl-3-x= 64.dll

dll

774,144

---A------= --

20/06/2023= 12:30

3.0.9.0

msvcp140.d= ll

dll

627,992

---A------= --

22/12/2021= 23:34

14.16.2703= 3.0

pgenlist.d= ll

dll

29,696

---A------= --

23/06/2023= 16:23

<unknow= n>

pgenlist.p= db

pdb

634,880

---A------= --

23/06/2023= 16:23

pgenlista.= dll

dll

29,696

---A------= --

23/06/2023= 16:23

<unknow= n>

pgenlista.= pdb

pdb

634,880

---A------= --

23/06/2023= 16:23

pgxalib.dl= l

dll

35,328

---A------= --

23/06/2023= 16:23

<unknow= n>

psqlodbc30= a.dll

dll

572,416

---A------= --

23/06/2023= 16:23

15.0.0.0

psqlodbc30= a.pdb

pdb

1,904,640<= o:p>

---A------= --

23/06/2023= 16:23

psqlodbc35= w.dll

dll

586,752

---A------= --

23/06/2023= 16:23

15.0.0.0

psqlodbc35= w.pdb

pdb

1,945,600<= o:p>

---A------= --

23/06/2023= 16:23

vcruntime1= 40.dll

dll

85,784

---A------= --

22/12/2021= 23:34

14.16.2703= 3.0

 = ;

That can c= onfirm that both older and newer versions consistently have no version for = some files.

Which seem= s to be in line with the previous answer.
All files shown here are in a subdir \psqlODBC\1500\bin.<= /p>

In a still= existing .\1302\bin only two files remain: libcrypto-1_1-x64.dll and libss= l-1_1-x64.dll.

So overwri= ting may not be what happens, but old version are removed/uninstalled and n= ew dll are written along with the newer/matching driver installation.

 = ;

I hope thi= s adds something useful for you.

 = ;

Jan Tjalling van der Wal

 <= /span>Wageningen Marine Reseach (WMR)  / formerly IMARES Institute for Marine Resources &&nbs= p;Ecosystem Studies

Ankerpark 27, 1781 AG Den Helder  =      Postbus 57, 1780 AB Den Helder

Tel. +31 (0)317-4 87147 #                     GSM. +31 (0)626120915 (priv=E9) #

# Ma+Di Vr 09:00-18:00, Wo XX, Do+Vr 09:00-18:00=

Jan_Tjalling.vanderWal@wur.nl

From: Dave Cramer <davecramer@postgres.rocks>
Sent: Thursday, October 26, 2023 11:51 AM
To: Mark Hill <Mark.Hill@sas.com>
Cc: pgsql-odbc@lists.postgresql.org
Subject: Re: pg*.dll and *.pdb files in psqlODBC have no version num= bers

 


 

 

On Wed, 25 Oct 2023 at 13:53, Mark Hill <Mark.Hill@sas.com> wrote:

I posted these questions to this group a few we= eks ago but haven’t received a response so reposting to
see if anybody has any ideas.=

We download the ODBC source from http://ftp.post= gresql.org<http://ftp.postgresql.org/> and build it on-site, 13.02.0= 000 in this case.


A colleague noticed that the following files in the psqlODBC MSI for Window= s 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 hav= e version numbers?


I checked earlier build and the same holds for ODBC 12.02.0000.

 

Doesn't look like we have ever versioned them. My gu= ess is that by not versioning them when you install the latest it overwrite= s the existing

 

Dave 


Thanks, Mark

 

--_000_AM0PR01MB56342C5B3D7E85BC923DC53CDDDDAAM0PR01MB5634eurp_--