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 1sC45R-002ykG-LD for pgsql-general@arkaria.postgresql.org; Tue, 28 May 2024 21:10:28 +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 1sC45Q-00Brcu-3e for pgsql-general@arkaria.postgresql.org; Tue, 28 May 2024 21:10:24 +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 1sC45P-00Brck-H0 for pgsql-general@lists.postgresql.org; Tue, 28 May 2024 21:10:23 +0000 Received: from securemail.mastercard.com ([216.119.215.10] helo=stleegwp1.mastercard.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 1sC45F-001Euu-Pv for pgsql-general@lists.postgresql.org; Tue, 28 May 2024 21:10:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mastercard.com; h=content-type : date : from : message-id : mime-version : subject : to; s=MCVM231; bh=bVy87tCQAhpNVei4JP5QLc95rtkjTnae6F8wjo+Pgfg=; b=PCSqI4i8RhoEWiJezDp5Sory3fTV2n3fhLuv646HVqfDjgNg65ir2VE+BLaZvt0g9gqZ gH1SfERv4uk6nRaGd4angyDVyg4buv4W8WTnXO27kh37mP7uAITP5Z1y/ZrX28jticrM 9EWCtSQrbuVrmHWtcXSjUREkL1XqdS+8spPXOZmpqjHcECrQLRPkI2YtkcerbUYG4tOa nh3XyMDKl2KkhpVZeeUhTAUmFvhMEl2pYU3d1T2sY0eXJT7c4RYCmwJex07yLwn8x6Dr QmAu6tsVwpKTkEq5zxeNNj/1WUG7yjMILopBjg00awgFbAVgOgZM1ZuN7wlYRHegRyrK fw== Received: from smtp.mastercard.com (KCI3VONT01.corp.mastercard.org [172.17.128.22]) by stleegwp1c.corp.mastercard.int (8.17.1.19/8.17.1.19) with ESMTPS id 44SLAArI015503 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NO) for ; Tue, 28 May 2024 16:10:10 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=T4IjH7onwHEZB6kDcrC4D2gIdRgKCPD3JNRFS9FIDoWwPFZ7QozntdIVHVJo0oIP87YxBsFqznOV8WUR49WV0FMHbWMuQQhJQ4+7CwWh/QpGhCiq7vhB7/lTKEhaUqUNkLcj9FpdGG6pLDIBNftlc9ldXKvnOJsU/zmROITHdwaJYM8SkBpxEGSGuJTzDO7viz2GJQSCOL0UK2/gawCSBe7jtTVLLMHDUYp90wApL7tWUocbfMNDsBKKCSDAtMqyQdAaSMay3QFVqHzVbAJfGgpAczlyYGxOysdoPyOTkAzx+KjUO9xk74Zzcw9oXxphhgxU7TkF8KhWFxZq+ejGlg== 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=bVy87tCQAhpNVei4JP5QLc95rtkjTnae6F8wjo+Pgfg=; b=d+obu08AHb1cuvfy0wTao+Jv6myAUJcrq77vO0pSID/PsE2H806gIifHY/dVUzygZydwEqe5e5YXowbMTvEp4VuTj2em7C7/K93iV4Vfu2HRzeNmj/s46gsvTtAB0OruCd43Li50zFQY8Fu7nRTOaqYkTpF/tnA9wsaq2h786uxeIJpf0+VcuQartBOFnPNgV1fNY6ooYQz8DpmpXfQR4rBx7wkw/qonpen/sLuUvCCTcPYiERo7DyD6iWlTtS4lA+kcN8X8n/LhIU6sa3K4cT0GiAm9ZuEZVyqjx6Z+1HOU4aOxZiGlaLW4Hb+aGoRkF7KSf2kS4M5oyKX3lLXYNA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=mastercard.com; dmarc=pass action=none header.from=mastercard.com; dkim=pass header.d=mastercard.com; arc=none From: Sumit Kochar To: "pgsql-general@lists.postgresql.org" Subject: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Thread-Topic: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Thread-Index: AdqxQcfpMUBHXUiSQu6x7184PJbLFA== Date: Tue, 28 May 2024 21:10:05 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_ActionId=0082f271-8da5-44ac-a3df-f83efc2943e5;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_ContentBits=0;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_Enabled=true;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_Method=Privileged;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_Name=Restricted;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_SetDate=2024-05-28T21:10:03Z;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_SiteId=f06fa858-824b-4a85-aacb-f372cfdc282e; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PH7PR14MB5367:EE_|SJ2PR14MB6661:EE_ x-ms-office365-filtering-correlation-id: c4f2addf-9798-46b5-e380-08dc7f5a8be7 x-disclaimer: Yes x-pptenantcode: ?s\*W[Y]a:S8F8{} x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230031|366007|1800799015|376005|38070700009; x-microsoft-antispam-message-info: =?us-ascii?Q?PlSygZVaoL1/Q6KBal9RJYqIvLksGKa5qrIXJLwGolYgE4StNfP2hDqHlLah?= =?us-ascii?Q?JEtWhtakNYwlsY5mZEAp4HSPjK9kxny8knFuQ/gdjCZUeNuHxAdnckNi+vsO?= =?us-ascii?Q?RmrhL+HodsghIQrdZQ+ayzQMhAVeIvRnsFZpmbmktyC3+FbXoVTKDXVIw3Ci?= =?us-ascii?Q?Kw7wggvwChDbozAFh2bLgZBnQ3T9Bhidqzf6TYvVMJWOVIZl6h6gceGMrqf2?= =?us-ascii?Q?BTaSaHunk1uGFkdfvASpWMuomSMES9yqw02eBKICYZ0QI5YJcGAmnGtYPEYp?= =?us-ascii?Q?MpjOa0soXGMh3yLg/V+BhTxKXgWpZp4dtx8ggJxHEEd4n5d3pliw8C4RVleC?= =?us-ascii?Q?Ky/NWdDPgEkYJdWnGZY37GD2LIWAxPW08FXMCVB+6mGJFBIOCiPeY4/vpLtJ?= =?us-ascii?Q?sBJpek6I2jo2hX8aA5peDFHlSkUFzvb9n6YgocYmzw6prAyD6q9pt2MrHQzG?= =?us-ascii?Q?LYEksHW1bN8B0cFmq0XlLlWsIdjfpCuKkJWFrn0NOj49jVKKJHvi7SX7ts/H?= =?us-ascii?Q?KJ4/n9FCRIPVFt/Prb/aZ+3vXROQLW8nqVaY1tf7brMtceloJHfdrh7z5Z6b?= =?us-ascii?Q?wwv/3OGhZOXER0VIhiAMnfYalesuA26MO2ynmdrk2widyYozgyz7EmjWeEnm?= =?us-ascii?Q?V2Ituyr6rO3UhKyqGkQoXHqQIGRz5yiFWFZ85egPoeJ1IN6FZf7jFCpg1JLN?= =?us-ascii?Q?kda9/W3G3EqOO2rcP158DqCk4qor/4pPhhlQhqN5hXzdeU+ysa/pEDQObGSp?= =?us-ascii?Q?H2zI1ynlPKBi3okDAxZi0BVet7DrpAoD55o0mElhXXWs/h28qFfTWib0VY17?= =?us-ascii?Q?VPgqiIyTUzvg3MDgBUvIYyDmUWJYrox0/S8/2WGe9y8QBXIGqWWU7xZw2BbF?= =?us-ascii?Q?Af11JYPl5/vVUn+Du+LX2g6gf0F0mrqpyl4j/cwsnM9HDjAc0jrgcqkk1ddk?= =?us-ascii?Q?gCj6ZS+U30J3z8j8+r8sisR2tpe/+FhGRwOGuA8RbxAjlSw/pBqXvCzazAJR?= =?us-ascii?Q?S/2ZErkfeyyaVSZw90gz1X3DB2f4MRdOgoqHD8GBZMFuCwPOPmXERUq3mdQK?= =?us-ascii?Q?iG1BC+hex3T3al4vAAQpuW5DqCyZI9jFpfdDO03x2XxFj8uOunQzBH575Bkm?= =?us-ascii?Q?wS4zHoaS8BSkRsxS3eVVjukzV1GDfV491M766xc/n6xkVyt8AtwRruvTkUqT?= =?us-ascii?Q?1+TF3QAJ8QBPVdYcIwKXRjN1MdI98L2UemDCgja+AH1yfrT+3/m8kIB5qUXB?= =?us-ascii?Q?hZolqpmS8eFtsh8A3Is+U2vfUYPTOGYdO4Tf6AQspuQpOMKayStQDXVA8dyk?= =?us-ascii?Q?IAk=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PH7PR14MB5367.namprd14.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(366007)(1800799015)(376005)(38070700009);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?yq02QRyR8ghylCzLj+Z+VCGyM58g0c3DwirwpEMcDiwUVy10euDtAUESWqdS?= =?us-ascii?Q?VKitGf3AFDOvmsQSYh5NVcPnUNNrdoAg/vtVqYjRwGUeM7znpJUgbw17u1F9?= =?us-ascii?Q?1GUd482cDvIq6LtLHUkGiKlz4bJ4ensa6X5e+drTHBNBakD6sOO+kIO5vtSE?= =?us-ascii?Q?rfhTx59GGFpDIhsll58xNbxCZUbQuNdiB3IV2Xl6vw09OayF9DdVoDqY2Vow?= =?us-ascii?Q?HtRr3/njW+9Eo6scW9tSvcD92JErhuvdg+qxb7Z5w/95seGuZM8cRhltsldb?= =?us-ascii?Q?WxFqgD3DltGIsheuU6tjEQREgAWEeWBqyjQMsLlYdcshnMLHabhWt5HW+A/+?= =?us-ascii?Q?qsRs2fCO0jf8tgtWOcmHiVrW/89tGYFYN5eQDr+jPQ22XSoCLogHZzML7/8J?= =?us-ascii?Q?YbVxpHfqMiUpNGDQStI6PTnf5IcTAW63dJ5cNjyJJmPCPcCMaJ/NqKV2GxsT?= =?us-ascii?Q?Y5+gcVVRXpF4lb4gibR1o2swMYLfe2fGbIOJ54R6mRCsceoI9meM3JGE9LYY?= =?us-ascii?Q?CaM27b0wAad65QB/djnZgDMEwaShZ19b/DYeukO7z5iIWK+8FdACJ/zGQZ+2?= =?us-ascii?Q?r1tyU6tC3ZXrVA22XDpaY91spWDQLmvhXcnHQ4T/l+7ZIgRtMiP4fr42BRxw?= =?us-ascii?Q?t6MUI5LbKEeJEc3q6TZYPMtavzIujKVci1f/Mg9SmGvhtyQd63tYXtISwKdB?= =?us-ascii?Q?NOfigJtcYQ8zPfW4/uvrEYo7UbISar+rw8OXRWoCHy/t5RMrpnb0xiOQDdD9?= =?us-ascii?Q?cYgbsGSA6mRGs8zxA0MwOJPCkWt/A4Xlyb1MJ/cEbqby3C7h22/FAKEN8mOM?= =?us-ascii?Q?7aUvWcnL5VrpzxOZl+4/KLFLGVwit04NiLCRr8tpxDKZnjQX+dqDUtcz5Duj?= =?us-ascii?Q?4VqoXsfgP168ZJ1o4XeakMNM+c3zzmTeqnPoA3shzbTalItU95nhojrfAoLp?= =?us-ascii?Q?zi36Gf7hwiOBrv+ObglzSVs3ej+/DUl1kcNUqoY0wJiwQ8Ma3+CzzAwBo94f?= =?us-ascii?Q?T8tbrfL8lDXV6Y1KKe9oqJGZD0yZmJaJ0Eq/vzPsgz13C6h9jjqX1DSvGatz?= =?us-ascii?Q?1dRS2U9v4fqLkuY/Ys+64gMoNnsvb6sjwi+4ky0nkIuZMzI2qJ00VENMOUNa?= =?us-ascii?Q?1LibHXAE7g4+XuXrSjX0LFZhdNKsHAwetKReNRvP9SlKlig0/3VMb+veTfWH?= =?us-ascii?Q?NcVzC3O0P5DTZyQzr/LQg6ncL0mfbljQCOcYuKMwBKG0lajSCzgd2k+Wjtrb?= =?us-ascii?Q?e2lLUb3YBjJNJ1C9AYlmlrnI+UogWzrT1FptNEN9fUaDfXoJCvdBFb9ovqoA?= =?us-ascii?Q?usf4DrhxYR+T/3fOickdfWQUatbb53avF2Ne9eI/7yE4BnZBZ//AGZyTH9Jy?= =?us-ascii?Q?N15qM22zOJPn1mb4/Gc2W+atoKyHdk0+DImefh5z/6axe0mghXN0e7lKnfQf?= =?us-ascii?Q?Uf+l2QEsIykPn2bTzJsVY8yT+c67LZrbLspq8iIIzVCuIonYMFdLCWIPx5m+?= =?us-ascii?Q?f7UvOvrDxJImXhXgM9270/U5nV/g+eLsd4xe1czlGbXEcv2ZoAqGzK24nKpY?= =?us-ascii?Q?5ogDXkk3W0ZcDZ7Pmb0ymeEB08iZ0eAXIGn2XChflitV1In7p0J0TDXzf/Iu?= =?us-ascii?Q?EA=3D=3D?= Content-Type: multipart/alternative; boundary="_000_PH7PR14MB53674648EB083CD246900B65F9F12PH7PR14MB5367namp_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PH7PR14MB5367.namprd14.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: c4f2addf-9798-46b5-e380-08dc7f5a8be7 X-MS-Exchange-CrossTenant-originalarrivaltime: 28 May 2024 21:10:05.0722 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: f06fa858-824b-4a85-aacb-f372cfdc282e X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: pYZa56jMOb2qg1zjFxVYxBChwnfTIUO4J+lrlu4wv44Tb7VHpFzVLmF1sRfF9dhJkhfJz3eFtCTiEMoRqW0w7Q4YrZ1I5naEwl1dQpnzGZQ= X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ2PR14MB6661 X-OriginatorOrg: mastercard.com X-CFilter-Loop: Reflected List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PH7PR14MB53674648EB083CD246900B65F9F12PH7PR14MB5367namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Installation of Foreign data Wrapper on EDB Postgres to connect to SQL serv= er database is not working. https://github.com/tds-fdw/tds_fdw/issues/357 Please advise if this has been encountered or a workaround is available. OS: NAME=3D"Oracle Linux Server" VERSION=3D"7.9" ID=3D"ol" ID_LIKE=3D"fedora" VARIANT=3D"Server" VARIANT_ID=3D"server" VERSION_ID=3D"7.9" PRETTY_NAME=3D"Oracle Linux Server 7.9" ANSI_COLOR=3D"0;31" CPE_NAME=3D"cpe:/o:oracle:linux:7:9:server" HOME_URL=3Dhttps://linux.oracle.com/ BUG_REPORT_URL=3Dhttps://github.com/oracle/oracle-linux ORACLE_BUGZILLA_PRODUCT=3D"Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=3D7.9 ORACLE_SUPPORT_PRODUCT=3D"Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=3D7.9 Version of tds_fdw: postgres=3D# \dx List of installed extensions Name | Version | Schema | Description ------------------+---------+------------+---------------------------------= --------------------- edb_dblink_libpq | 1.0 | pg_catalog | EnterpriseDB Foreign Data Wrappe= r for PostgreSQL edb_dblink_oci | 1.0 | pg_catalog | EnterpriseDB Foreign Data Wrappe= r for Oracle edbspl | 1.0 | pg_catalog | EDB-SPL procedural language pldbgapi | 1.1 | pg_catalog | server-side support for debuggin= g PL/pgSQL functions plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language (5 rows) PostgreSQL Version: postgres=3D# SELECT version(); versio= n ---------------------------------------------------------------------------= ----------------------------------------------------------------------- PostgreSQL 13.13 (EnterpriseDB Advanced Server 13.13.19) on x86_64-pc-linu= x-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit (1 row) Issue Details: tds_fdw install steps performed: yum install install edb-as13-server edb-as13-server-libs edb-as13-server-de= vel yum install -y gcc make wget epel-release freetds freetds-devel dnf install redhat-rpm-config subscription-manager repos --enable rhel-7-server-optional-rpms \ --enable rhel-server-rhscl-7-rpms \ --enable rhel-7-server-devtools-rpms yum install llvm-toolset-7-clang-analyzer llvm-toolset-7-clang-tools-extra = llvm-toolset-7 llvm-toolset-7-clang llvm-toolset-7-clang-libs llvm-toolset= -7-llvm-libs export TDS_FDW_VERSION=3D"2.0.3" wget https://github.com/tds-fdw/tds_fdw/archive/refs/tags/v2.0.3.tar.gz -O = tds_fdw-${TDS_FDW_VERSION}.tar.gz tar -xvzf tds_fdw-${TDS_FDW_VERSION}.tar.gz cd tds_fdw-${TDS_FDW_VERSION} PATH=3D/usr/edb/as13/bin:$PATH make USE_PGXS=3D1 PATH=3D/usr/edb/as13/bin:$PATH make USE_PGXS=3D1 install Logs: [root@hostip ~]# yum install install edb-as13-server edb-as13-server-libs e= db-as13-server-devel\ Loaded plugins: rhnplugin\ This system is not registered with Spacewalk server.\ You can use rhn_register to register.\ Spacewalk support will be disabled.\ Repository mc-ol7-base-x86_64 is listed more than once in the configuration= \ Repository mc-ol7-layered-x86_64 is listed more than once in the configurat= ion\ Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configu= ration\ Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the con= figuration\ No package install available.\ Package edb-as13-server-13.13.19-1.el7.x86_64 already installed and latest = version\ Package edb-as13-server-libs-13.13.19-1.el7.x86_64 already installed and la= test version\ Package edb-as13-server-devel-13.13.19-1.el7.x86_64 already installed and l= atest version\ Nothing to do\ [root@hostip ~]#\ [root@hostip ~]# yum install -y gcc make wget epel-release freetds freetds-= devel\ Loaded plugins: rhnplugin\ This system is not registered with Spacewalk server.\ You can use rhn_register to register.\ Spacewalk support will be disabled.\ Repository mc-ol7-base-x86_64 is listed more than once in the configuration= \ Repository mc-ol7-layered-x86_64 is listed more than once in the configurat= ion\ Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configu= ration\ Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the con= figuration\ Package gcc-4.8.5-44.0.3.el7.x86_64 already installed and latest version\ Package 1:make-3.82-24.el7.x86_64 already installed and latest version\ Package wget-1.14-18.el7_6.1.x86_64 already installed and latest version\ Package epel-release-7-14.noarch already installed and latest version\ Package freetds-1.3.3-1.el7.x86_64 already installed and latest version\ Package freetds-devel-1.3.3-1.el7.x86_64 already installed and latest versi= on\ Nothing to do\ [root@hostip ~]#\ [root@hostip ~]# dnf install redhat-rpm-config\ -bash: dnf: command not found\ [root@hostip ~]#\ [root@hostip ~]# subscription-manager repos --enable rhel-7-server-optional= -rpms \ --enable rhel-server-rhscl-7-rpms \ --enable rhel-7-server-devtools= -rpms\ -bash: subscription-manager: command not found\ [root@hostip ~]#\ [root@hostip ~]#\ [root@hostip ~]# yum install llvm-toolset-7-clang-analyzer llvm-toolset-7-c= lang-tools-extra llvm-toolset-7 llvm-toolset-7-clang llvm-toolset-7-clang-l= ibs llvm-toolset-7-llvm-libs\ Loaded plugins: rhnplugin\ This system is not registered with Spacewalk server.\ You can use rhn_register to register.\ Spacewalk support will be disabled.\ Repository mc-ol7-base-x86_64 is listed more than once in the configuration= \ Repository mc-ol7-layered-x86_64 is listed more than once in the configurat= ion\ Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configu= ration\ Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the con= figuration\ **No package llvm-toolset-7-clang-analyzer available.\ No package llvm-toolset-7-clang-tools-extra available.\ No package llvm-toolset-7 available.\ No package llvm-toolset-7-clang available.\ No package llvm-toolset-7-clang-libs available.\ No package llvm-toolset-7-llvm-libs available.\** Error: Nothing to do\ [root@hostip ~]#\ [root@hostip ~]# [root@hostip ~]# [root@hostip ~]# export TDS_FDW_VERSION=3D"2.0.3" [root@hostip ~]# wget https://github.com/tds-fdw/tds_fdw/archive/refs/tags/= v2.0.3.tar.gz -O tds_fdw-${TDS_FDW_VERSION}.tar.gz --2024-05-28 15:44:39-- https://github.com/tds-fdw/tds_fdw/archive/refs/ta= gs/v2.0.3.tar.gz Resolving github.com (github.com)... 140.82.112.4 Connecting to github.com (github.com)|140.82.112.4|:443... connected. HTTP request sent, awaiting response... 302 Found Location: https://codeload.github.com/tds-fdw/tds_fdw/tar.gz/refs/tags/v2.0= .3 [following] --2024-05-28 15:44:39-- https://codeload.github.com/tds-fdw/tds_fdw/tar.gz= /refs/tags/v2.0.3 Resolving codeload.github.com (codeload.github.com)... 140.82.113.10 Connecting to codeload.github.com (codeload.github.com)|140.82.113.10|:443.= .. connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [application/x-gzip] Saving to: 'tds_fdw-2.0.3.tar.gz' [ <=3D> = = ] 72,5= 27 --.-K/s in 0.05s 2024-05-28 15:44:39 (1.50 MB/s) - 'tds_fdw-2.0.3.tar.gz' saved [72527] [root@hostip ~]# [root@hostip ~]# tar -xvzf tds_fdw-${TDS_FDW_VERSION}.tar.gz tds_fdw-2.0.3/ tds_fdw-2.0.3/.gitattributes tds_fdw-2.0.3/.github/ tds_fdw-2.0.3/.github/ISSUE_TEMPLATE.md tds_fdw-2.0.3/.gitignore tds_fdw-2.0.3/ForeignSchemaImporting.md tds_fdw-2.0.3/ForeignServerCreation.md tds_fdw-2.0.3/ForeignTableCreation.md tds_fdw-2.0.3/InstallAlpine.md tds_fdw-2.0.3/InstallDebian.md tds_fdw-2.0.3/InstallOSX.md tds_fdw-2.0.3/InstallRHELandClones.md tds_fdw-2.0.3/InstallUbuntu.md tds_fdw-2.0.3/InstallopenSUSE.md tds_fdw-2.0.3/LICENSE tds_fdw-2.0.3/META.json tds_fdw-2.0.3/Makefile tds_fdw-2.0.3/README.md tds_fdw-2.0.3/UserMappingCreation.md tds_fdw-2.0.3/Variables.md tds_fdw-2.0.3/include/ tds_fdw-2.0.3/include/deparse.h tds_fdw-2.0.3/include/options.h tds_fdw-2.0.3/include/tds_fdw.h tds_fdw-2.0.3/include/visibility.h tds_fdw-2.0.3/logo/ tds_fdw-2.0.3/logo/tds_fdw.svg tds_fdw-2.0.3/sql/ tds_fdw-2.0.3/sql/tds_fdw.sql tds_fdw-2.0.3/src/ tds_fdw-2.0.3/src/deparse.c tds_fdw-2.0.3/src/options.c tds_fdw-2.0.3/src/tds_fdw.c tds_fdw-2.0.3/tds_fdw.control tds_fdw-2.0.3/tests/ tds_fdw-2.0.3/tests/.gitignore tds_fdw-2.0.3/tests/README.md tds_fdw-2.0.3/tests/lib/ tds_fdw-2.0.3/tests/lib/__init__.py tds_fdw-2.0.3/tests/lib/messages.py tds_fdw-2.0.3/tests/lib/tests.py tds_fdw-2.0.3/tests/mssql-tests.py tds_fdw-2.0.3/tests/postgresql-tests.py tds_fdw-2.0.3/tests/tests/ tds_fdw-2.0.3/tests/tests/mssql/ tds_fdw-2.0.3/tests/tests/mssql/000_create_schema.json tds_fdw-2.0.3/tests/tests/mssql/000_create_schema.sql tds_fdw-2.0.3/tests/tests/mssql/001_create_tinyint_min_table.json tds_fdw-2.0.3/tests/tests/mssql/001_create_tinyint_min_table.sql tds_fdw-2.0.3/tests/tests/mssql/002_create_tinyint_max_table.json tds_fdw-2.0.3/tests/tests/mssql/002_create_tinyint_max_table.sql tds_fdw-2.0.3/tests/tests/mssql/003_create_smallint_min_table.json tds_fdw-2.0.3/tests/tests/mssql/003_create_smallint_min_table.sql tds_fdw-2.0.3/tests/tests/mssql/004_create_smallint_max_table.json tds_fdw-2.0.3/tests/tests/mssql/004_create_smallint_max_table.sql tds_fdw-2.0.3/tests/tests/mssql/005_create_int_min_table.json tds_fdw-2.0.3/tests/tests/mssql/005_create_int_min_table.sql tds_fdw-2.0.3/tests/tests/mssql/006_create_int_max_table.json tds_fdw-2.0.3/tests/tests/mssql/006_create_int_max_table.sql tds_fdw-2.0.3/tests/tests/mssql/007_create_bigint_min_table.json tds_fdw-2.0.3/tests/tests/mssql/007_create_bigint_min_table.sql tds_fdw-2.0.3/tests/tests/mssql/008_create_bigint_max_table.json tds_fdw-2.0.3/tests/tests/mssql/008_create_bigint_max_table.sql tds_fdw-2.0.3/tests/tests/mssql/009_create_decimal_table.json tds_fdw-2.0.3/tests/tests/mssql/009_create_decimal_table.sql tds_fdw-2.0.3/tests/tests/mssql/010_create_float4_table.json tds_fdw-2.0.3/tests/tests/mssql/010_create_float4_table.sql tds_fdw-2.0.3/tests/tests/mssql/011_create_float8_table.json tds_fdw-2.0.3/tests/tests/mssql/011_create_float8_table.sql tds_fdw-2.0.3/tests/tests/mssql/012_create_date_table.json tds_fdw-2.0.3/tests/tests/mssql/012_create_date_table.sql tds_fdw-2.0.3/tests/tests/mssql/013_create_time_table.json tds_fdw-2.0.3/tests/tests/mssql/013_create_time_table.sql tds_fdw-2.0.3/tests/tests/mssql/014_create_datetime_table.json tds_fdw-2.0.3/tests/tests/mssql/014_create_datetime_table.sql tds_fdw-2.0.3/tests/tests/mssql/015_create_datetime2_table.json tds_fdw-2.0.3/tests/tests/mssql/015_create_datetime2_table.sql tds_fdw-2.0.3/tests/tests/mssql/016_create_datetimeoffset_table.json tds_fdw-2.0.3/tests/tests/mssql/016_create_datetimeoffset_table.sql tds_fdw-2.0.3/tests/tests/mssql/017_create_char_table.json tds_fdw-2.0.3/tests/tests/mssql/017_create_char_table.sql tds_fdw-2.0.3/tests/tests/mssql/018_create_varchar_table.json tds_fdw-2.0.3/tests/tests/mssql/018_create_varchar_table.sql tds_fdw-2.0.3/tests/tests/mssql/019_create_varcharmax_table.json tds_fdw-2.0.3/tests/tests/mssql/019_create_varcharmax_table.sql tds_fdw-2.0.3/tests/tests/mssql/020_create_binary4_table.json tds_fdw-2.0.3/tests/tests/mssql/020_create_binary4_table.sql tds_fdw-2.0.3/tests/tests/mssql/021_create_varbinary4_table.json tds_fdw-2.0.3/tests/tests/mssql/021_create_varbinary4_table.sql tds_fdw-2.0.3/tests/tests/mssql/022_create_varbinarymax_table.json tds_fdw-2.0.3/tests/tests/mssql/022_create_varbinarymax_table.sql tds_fdw-2.0.3/tests/tests/mssql/023_create_null_datetime_table.json tds_fdw-2.0.3/tests/tests/mssql/023_create_null_datetime_table.sql tds_fdw-2.0.3/tests/tests/mssql/024_create_null_datetime2_table.json tds_fdw-2.0.3/tests/tests/mssql/024_create_null_datetime2_table.sql tds_fdw-2.0.3/tests/tests/mssql/025_create_match_column_table.json tds_fdw-2.0.3/tests/tests/mssql/025_create_match_column_table.sql tds_fdw-2.0.3/tests/tests/mssql/026_create_column_name_table.json tds_fdw-2.0.3/tests/tests/mssql/026_create_column_name_table.sql tds_fdw-2.0.3/tests/tests/mssql/027_create_query_option_table.json tds_fdw-2.0.3/tests/tests/mssql/027_create_query_option_table.sql tds_fdw-2.0.3/tests/tests/mssql/028_create_view_simple_prerequisites.json tds_fdw-2.0.3/tests/tests/mssql/028_create_view_simple_prerequisites.sql tds_fdw-2.0.3/tests/tests/mssql/029_create_view_simple.json tds_fdw-2.0.3/tests/tests/mssql/029_create_view_simple.sql tds_fdw-2.0.3/tests/tests/postgresql/ tds_fdw-2.0.3/tests/tests/postgresql/000_create_schema.json tds_fdw-2.0.3/tests/tests/postgresql/000_create_schema.sql tds_fdw-2.0.3/tests/tests/postgresql/001_create_server.json tds_fdw-2.0.3/tests/tests/postgresql/001_create_server.sql tds_fdw-2.0.3/tests/tests/postgresql/002_create_user_mapping.json tds_fdw-2.0.3/tests/tests/postgresql/002_create_user_mapping.sql tds_fdw-2.0.3/tests/tests/postgresql/003_import_schema.json tds_fdw-2.0.3/tests/tests/postgresql/003_import_schema.sql tds_fdw-2.0.3/tests/tests/postgresql/004_tinyintmin.json tds_fdw-2.0.3/tests/tests/postgresql/004_tinyintmin.sql tds_fdw-2.0.3/tests/tests/postgresql/005_tinyintmax.json tds_fdw-2.0.3/tests/tests/postgresql/005_tinyintmax.sql tds_fdw-2.0.3/tests/tests/postgresql/006_smallintmin.json tds_fdw-2.0.3/tests/tests/postgresql/006_smallintmin.sql tds_fdw-2.0.3/tests/tests/postgresql/007_smallintmax.json tds_fdw-2.0.3/tests/tests/postgresql/007_smallintmax.sql tds_fdw-2.0.3/tests/tests/postgresql/008_intmin.json tds_fdw-2.0.3/tests/tests/postgresql/008_intmin.sql tds_fdw-2.0.3/tests/tests/postgresql/009_intmax.json tds_fdw-2.0.3/tests/tests/postgresql/009_intmax.sql tds_fdw-2.0.3/tests/tests/postgresql/010_bigintmin.json tds_fdw-2.0.3/tests/tests/postgresql/010_bigintmin.sql tds_fdw-2.0.3/tests/tests/postgresql/011_bigintmax.json tds_fdw-2.0.3/tests/tests/postgresql/011_bigintmax.sql tds_fdw-2.0.3/tests/tests/postgresql/012_decimal.json tds_fdw-2.0.3/tests/tests/postgresql/012_decimal.sql tds_fdw-2.0.3/tests/tests/postgresql/013_float4.json tds_fdw-2.0.3/tests/tests/postgresql/013_float4.sql tds_fdw-2.0.3/tests/tests/postgresql/014_float8.json tds_fdw-2.0.3/tests/tests/postgresql/014_float8.sql tds_fdw-2.0.3/tests/tests/postgresql/015_date.json tds_fdw-2.0.3/tests/tests/postgresql/015_date.sql tds_fdw-2.0.3/tests/tests/postgresql/016_time.json tds_fdw-2.0.3/tests/tests/postgresql/016_time.sql tds_fdw-2.0.3/tests/tests/postgresql/017_datetime.json tds_fdw-2.0.3/tests/tests/postgresql/017_datetime.sql tds_fdw-2.0.3/tests/tests/postgresql/018_datetime2.json tds_fdw-2.0.3/tests/tests/postgresql/018_datetime2.sql tds_fdw-2.0.3/tests/tests/postgresql/019_datetimeoffset.json tds_fdw-2.0.3/tests/tests/postgresql/019_datetimeoffset.sql tds_fdw-2.0.3/tests/tests/postgresql/020_char.json tds_fdw-2.0.3/tests/tests/postgresql/020_char.sql tds_fdw-2.0.3/tests/tests/postgresql/021_varchar.json tds_fdw-2.0.3/tests/tests/postgresql/021_varchar.sql tds_fdw-2.0.3/tests/tests/postgresql/022_varcharmax.json tds_fdw-2.0.3/tests/tests/postgresql/022_varcharmax.sql tds_fdw-2.0.3/tests/tests/postgresql/023_binary4.json tds_fdw-2.0.3/tests/tests/postgresql/023_binary4.sql tds_fdw-2.0.3/tests/tests/postgresql/024_varbinary4.json tds_fdw-2.0.3/tests/tests/postgresql/024_varbinary4.sql tds_fdw-2.0.3/tests/tests/postgresql/025_varbinarymax.json tds_fdw-2.0.3/tests/tests/postgresql/025_varbinarymax.sql tds_fdw-2.0.3/tests/tests/postgresql/026_null_datetime.json tds_fdw-2.0.3/tests/tests/postgresql/026_null_datetime.sql tds_fdw-2.0.3/tests/tests/postgresql/027_null_datetime2.json tds_fdw-2.0.3/tests/tests/postgresql/027_null_datetime2.sql tds_fdw-2.0.3/tests/tests/postgresql/028_column_match_enabled.json tds_fdw-2.0.3/tests/tests/postgresql/028_column_match_enabled.sql tds_fdw-2.0.3/tests/tests/postgresql/029_column_match_disabled.json tds_fdw-2.0.3/tests/tests/postgresql/029_column_match_disabled.sql tds_fdw-2.0.3/tests/tests/postgresql/030_column_name.json tds_fdw-2.0.3/tests/tests/postgresql/030_column_name.sql tds_fdw-2.0.3/tests/tests/postgresql/031_query_option_column_match_enabled.= json tds_fdw-2.0.3/tests/tests/postgresql/031_query_option_column_match_enabled.= sql tds_fdw-2.0.3/tests/tests/postgresql/032_query_option_column_match_disabled= .json tds_fdw-2.0.3/tests/tests/postgresql/032_query_option_column_match_disabled= .sql tds_fdw-2.0.3/tests/tests/postgresql/033_view_simple.json tds_fdw-2.0.3/tests/tests/postgresql/033_view_simple.sql tds_fdw-2.0.3/tests/tests/postgresql/034_explain.json tds_fdw-2.0.3/tests/tests/postgresql/034_explain.sql tds_fdw-2.0.3/tests/tests/postgresql/035_rescan.json tds_fdw-2.0.3/tests/tests/postgresql/035_rescan.sql tds_fdw-2.0.3/tests/validate-test-json [root@hostip ~]# [root@hostip ~]# cd tds_fdw-${TDS_FDW_VERSION} [root@hostip tds_fdw-2.0.3]# [root@hostip tds_fdw-2.0.3]# PATH=3D/usr/edb/as13/bin:$PATH [root@hostip tds_fdw-2.0.3]# [root@hostip tds_fdw-2.0.3]# make USE_PGXS=3D1 gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-a= fter-statement -Werror=3Dvla -Wendif-labels -Wmissing-format-attribute -Wfo= rmat-security -fno-strict-aliasing -fwrapv -fexcess-precision=3Dstandard -I= /usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=3D= 2 -fexceptions -fstack-protector-strong --param=3Dssp-buffer-size=3D4 -grec= ord-gcc-switches -m64 -mtune=3Dgeneric -fPIC -I./include/ -fvisibility=3D= hidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/int= ernal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml= 2 -I/usr/include -c -o src/tds_fdw.o src/tds_fdw.c gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-a= fter-statement -Werror=3Dvla -Wendif-labels -Wmissing-format-attribute -Wfo= rmat-security -fno-strict-aliasing -fwrapv -fexcess-precision=3Dstandard -I= /usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=3D= 2 -fexceptions -fstack-protector-strong --param=3Dssp-buffer-size=3D4 -grec= ord-gcc-switches -m64 -mtune=3Dgeneric -fPIC -I./include/ -fvisibility=3D= hidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/int= ernal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml= 2 -I/usr/include -c -o src/options.o src/options.c gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-a= fter-statement -Werror=3Dvla -Wendif-labels -Wmissing-format-attribute -Wfo= rmat-security -fno-strict-aliasing -fwrapv -fexcess-precision=3Dstandard -I= /usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=3D= 2 -fexceptions -fstack-protector-strong --param=3Dssp-buffer-size=3D4 -grec= ord-gcc-switches -m64 -mtune=3Dgeneric -fPIC -I./include/ -fvisibility=3D= hidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/int= ernal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml= 2 -I/usr/include -c -o src/deparse.o src/deparse.c gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-a= fter-statement -Werror=3Dvla -Wendif-labels -Wmissing-format-attribute -Wfo= rmat-security -fno-strict-aliasing -fwrapv -fexcess-precision=3Dstandard -I= /usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=3D= 2 -fexceptions -fstack-protector-strong --param=3Dssp-buffer-size=3D4 -grec= ord-gcc-switches -m64 -mtune=3Dgeneric -fPIC -shared -o tds_fdw.so src/td= s_fdw.o src/options.o src/deparse.o -L/usr/edb/as13/lib -L/usr/libexec/edb= -icu66/lib/ -L/usr/lib64/llvm5.0/lib -L/usr/lib64 -Wl,--as-needed -Wl,-rp= ath,'/usr/edb/as13/lib',--enable-new-dtags -lsybdb cp sql/tds_fdw.sql sql/tds_fdw--2.0.3.sql cp README.md README.tds_fdw.md /opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno-stri= ct-aliasing -fwrapv -Wno-unused-command-line-argument -O2 -I./include/ -fv= isibility=3Dhidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13= /include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/in= clude/libxml2 -I/usr/include -flto=3Dthin -emit-llvm -c -o src/tds_fdw.bc = src/tds_fdw.c make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found make: *** [src/tds_fdw.bc] Error 127 [root@hostip tds_fdw-2.0.3]# [root@hostip tds_fdw-2.0.3]# [root@hostip tds_fdw-2.0.3]# PATH=3D/usr/edb/as13/bin:$PATH [root@hostip tds_fdw-2.0.3]# make USE_PGXS=3D1 install /opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno-stri= ct-aliasing -fwrapv -Wno-unused-command-line-argument -O2 -I./include/ -fv= isibility=3Dhidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13= /include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/in= clude/libxml2 -I/usr/include -flto=3Dthin -emit-llvm -c -o src/tds_fdw.bc = src/tds_fdw.c make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found make: *** [src/tds_fdw.bc] Error 127 [root@hostip tds_fdw-2.0.3]# CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for= the use of the intended recipient and may contain information that is priv= ileged, confidential or exempt from disclosure under applicable law. If you= are not the intended recipient, any disclosure, distribution or other use = of this e-mail message or attachments is prohibited. If you have received t= his e-mail message in error, please delete and notify the sender immediatel= y. Thank you. --_000_PH7PR14MB53674648EB083CD246900B65F9F12PH7PR14MB5367namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Installation of Foreign data Wrapper on EDB Postgres= to connect to SQL server database is not working.

 

https://github.com/tds-fdw/tds_fdw/issues/357

 

Please advise if this has been encountered or a work= around is available.

 

OS:

 

NAME=3D"Oracle Linux Server"

VERSION=3D"7.9"

ID=3D"ol"

ID_LIKE=3D"fedora"

VARIANT=3D"Server"

VARIANT_ID=3D"server"

VERSION_ID=3D"7.9"

PRETTY_NAME=3D"Oracle Linux Server 7.9"=

ANSI_COLOR=3D"0;31"

CPE_NAME=3D"cpe:/o:oracle:linux:7:9:server"

HOME_URL=3Dhttps://lin= ux.oracle.com/

BUG_REPORT_URL=3Dhttps://github.com/oracle/oracle-linux

 

ORACLE_BUGZILLA_PRODUCT=3D"Oracle Linux 7"

ORACLE_BUGZILLA_PRODUCT_VERSION=3D7.9

ORACLE_SUPPORT_PRODUCT=3D"Oracle Linux"=

ORACLE_SUPPORT_PRODUCT_VERSION=3D7.9

 

 

Version of tds_fdw:

postgres=3D# \dx=
        &nbs=
p;            &=
nbsp;            Lis=
t of installed extensions
       Name  =
;     | Version |   Schema   | =
;            &n=
bsp;       Description
------------------+---------+------------+----------=
--------------------------------------------
 edb_dblink_libpq | 1.0     | pg=
_catalog | EnterpriseDB Foreign Data Wrapper for PostgreSQL
 edb_dblink_oci   | 1.0   &=
nbsp; | pg_catalog | EnterpriseDB Foreign Data Wrapper for Oracle
 edbspl       &nb=
sp;   | 1.0     | pg_catalog | EDB-SPL proced=
ural language
 pldbgapi       &=
nbsp; | 1.1     | pg_catalog | server-side support for =
debugging PL/pgSQL functions
 plpgsql       &n=
bsp;  | 1.0     | pg_catalog | PL/pgSQL procedural=
 language
(5 rows)

 

 

PostgreSQL Version:

 

postgres=3D# SELECT version();
        &nbs=
p;            &=
nbsp;           &nbs=
p;            &=
nbsp;           &nbs=
p;          version=
----------------------------------------------------=
---------------------------------------------------------------------------=
-------------------
 PostgreSQL 13.13 (EnterpriseDB Advanced Server 13.1=
3.19) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat=
 4.8.5-44), 64-bit
(1 row)

 

 

Issue Details:

 

tds_fdw install steps performed:
 
 
yum install install edb-as13-server edb-as13-server-=
libs edb-as13-server-devel
yum install -y gcc make wget epel-release freetds fr=
eetds-devel 
dnf install redhat-rpm-config
subscription-manager repos --enable rhel-7-server-op=
tional-rpms \
    --enable rhel-server-rhscl-7-rpms=
 \
    --enable rhel-7-server-devtools-r=
pms
yum install llvm-toolset-7-clang-analyzer llvm-tools=
et-7-clang-tools-extra llvm-toolset-7 llvm-toolset-7-clang llvm-toolset-7-c=
lang-libs  llvm-toolset-7-llvm-libs
 
 
export TDS_FDW_VERSION=3D"2.0.3" 
wget https://github.com/tds-fdw/tds_fdw/archive/=
refs/tags/v2.0.3.tar.gz -O tds_fdw-${TDS_FDW_VERSION}.tar.gz 
tar -xvzf tds_fdw-${TDS_FDW_VERSION}.tar.gz 
cd tds_fdw-${TDS_FDW_VERSION} 
PATH=3D/usr/edb/as13/bin:$PATH 
make USE_PGXS=3D1 
PATH=3D/usr/edb/as13/bin:$PATH 
make USE_PGXS=3D1 install
 
 
Logs:
 
 
[root@hostip ~]# yum install install edb-as13-server=
 edb-as13-server-libs edb-as13-server-devel\
Loaded plugins: rhnplugin\<=
/pre>
This system is not registered with Spacewalk server.=
\
You can use rhn_register to register.\
Spacewalk support will be disabled.\
Repository mc-ol7-base-x86_64 is listed more than on=
ce in the configuration\
Repository mc-ol7-layered-x86_64 is listed more than=
 once in the configuration\
Repository mc-ol7_tsm-8.1.13_x86_64 is listed more t=
han once in the configuration\
Repository mc-ol7-chef_client_15-x86_64 is listed mo=
re than once in the configuration\
No package install available.\
Package edb-as13-server-13.13.19-1.el7.x86_64 alread=
y installed and latest version\
Package edb-as13-server-libs-13.13.19-1.el7.x86_64 a=
lready installed and latest version\
Package edb-as13-server-devel-13.13.19-1.el7.x86_64 =
already installed and latest version\
Nothing to do\
[root@hostip ~]#\
[root@hostip ~]# yum install -y gcc make wget epel-r=
elease freetds freetds-devel\
Loaded plugins: rhnplugin\<=
/pre>
This system is not registered with Spacewalk server.=
\
You can use rhn_register to register.\
Spacewalk support will be disabled.\
Repository mc-ol7-base-x86_64 is listed more than on=
ce in the configuration\
Repository mc-ol7-layered-x86_64 is listed more than=
 once in the configuration\
Repository mc-ol7_tsm-8.1.13_x86_64 is listed more t=
han once in the configuration\
Repository mc-ol7-chef_client_15-x86_64 is listed mo=
re than once in the configuration\
Package gcc-4.8.5-44.0.3.el7.x86_64 already installe=
d and latest version\
Package 1:make-3.82-24.el7.x86_64 already installed =
and latest version\
Package wget-1.14-18.el7_6.1.x86_64 already installe=
d and latest version\
Package epel-release-7-14.noarch already installed a=
nd latest version\
Package freetds-1.3.3-1.el7.x86_64 already installed=
 and latest version\
Package freetds-devel-1.3.3-1.el7.x86_64 already ins=
talled and latest version\
Nothing to do\
[root@hostip ~]#\
[root@hostip ~]# dnf install redhat-rpm-config\=
-bash: dnf: command not found\
[root@hostip ~]#\
[root@hostip ~]# subscription-manager repos --enable=
 rhel-7-server-optional-rpms \ --enable rhel-server-rhscl-7-rpms \ --enable=
 rhel-7-server-devtools-rpms\
-bash: subscription-manager: command not found\=
[root@hostip ~]#\
[root@hostip ~]#\
[root@hostip ~]# yum install llvm-toolset-7-clang-an=
alyzer llvm-toolset-7-clang-tools-extra llvm-toolset-7 llvm-toolset-7-clang=
 llvm-toolset-7-clang-libs llvm-toolset-7-llvm-libs\
Loaded plugins: rhnplugin\<=
/pre>
This system is not registered with Spacewalk server.=
\
You can use rhn_register to register.\
Spacewalk support will be disabled.\
Repository mc-ol7-base-x86_64 is listed more than on=
ce in the configuration\
Repository mc-ol7-layered-x86_64 is listed more than=
 once in the configuration\
Repository mc-ol7_tsm-8.1.13_x86_64 is listed more t=
han once in the configuration\
Repository mc-ol7-chef_client_15-x86_64 is listed mo=
re than once in the configuration\
**No package llvm-toolset-7-clang-analyzer available=
.\
No package llvm-toolset-7-clang-tools-extra availabl=
e.\
No package llvm-toolset-7 available.\
No package llvm-toolset-7-clang available.\
No package llvm-toolset-7-clang-libs available.\
No package llvm-toolset-7-llvm-libs available.\**
Error: Nothing to do\
[root@hostip ~]#\
[root@hostip ~]#
 
 
 
 
 
 
[root@hostip ~]#
[root@hostip ~]# export TDS_FDW_VERSION=3D"2.0.=
3"
[root@hostip ~]# wget https://github.com/tds-fdw=
/tds_fdw/archive/refs/tags/v2.0.3.tar.gz -O tds_fdw-${TDS_FDW_VERSION}.=
tar.gz
--2024-05-28 15:44:39--  https://github.com=
/tds-fdw/tds_fdw/archive/refs/tags/v2.0.3.tar.gz
Resolving github.com (github.com)... 140.82.112.4
Connecting to github.com (github.com)|140.82.112.4|:=
443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://codeload.github.com/tds-fdw/t=
ds_fdw/tar.gz/refs/tags/v2.0.3 [following]
--2024-05-28 15:44:39--  https://codeload.=
github.com/tds-fdw/tds_fdw/tar.gz/refs/tags/v2.0.3
Resolving codeload.github.com (codeload.github.com).=
.. 140.82.113.10
Connecting to codeload.github.com (codeload.github.c=
om)|140.82.113.10|:443... connected.
HTTP request sent, awaiting response... 200 OK<=
/o:p>
Length: unspecified [application/x-gzip]<=
/span>
Saving to: ‘tds_fdw-2.0.3.tar.gz’
 
    [ <=3D>   &n=
bsp;            =
;            &n=
bsp;            =
;            &n=
bsp;            =
;            &n=
bsp;            =
;            &n=
bsp;            =
;            &n=
bsp;            =
;            &n=
bsp;            =
;            &n=
bsp;            =
;            &n=
bsp;    ] 72,527      --.-K/s =
  in 0.05s
 
2024-05-28 15:44:39 (1.50 MB/s) - ‘tds_fdw-2.0=
.3.tar.gz’ saved [72527]
 
[root@hostip ~]#
[root@hostip ~]# tar -xvzf tds_fdw-${TDS_FDW_VERSION=
}.tar.gz
tds_fdw-2.0.3/
tds_fdw-2.0.3/.gitattributes
tds_fdw-2.0.3/.github/
tds_fdw-2.0.3/.github/ISSUE_TEMPLATE.md
tds_fdw-2.0.3/.gitignore
tds_fdw-2.0.3/ForeignSchemaImporting.md
tds_fdw-2.0.3/ForeignServerCreation.md
tds_fdw-2.0.3/ForeignTableCreation.md
tds_fdw-2.0.3/InstallAlpine.md
tds_fdw-2.0.3/InstallDebian.md
tds_fdw-2.0.3/InstallOSX.md=
tds_fdw-2.0.3/InstallRHELandClones.md
tds_fdw-2.0.3/InstallUbuntu.md
tds_fdw-2.0.3/InstallopenSUSE.md
tds_fdw-2.0.3/LICENSE
tds_fdw-2.0.3/META.json
tds_fdw-2.0.3/Makefile
tds_fdw-2.0.3/README.md
tds_fdw-2.0.3/UserMappingCreation.md
tds_fdw-2.0.3/Variables.md<=
/pre>
tds_fdw-2.0.3/include/
tds_fdw-2.0.3/include/deparse.h
tds_fdw-2.0.3/include/options.h
tds_fdw-2.0.3/include/tds_fdw.h
tds_fdw-2.0.3/include/visibility.h=
tds_fdw-2.0.3/logo/
tds_fdw-2.0.3/logo/tds_fdw.svg
tds_fdw-2.0.3/sql/
tds_fdw-2.0.3/sql/tds_fdw.sql
tds_fdw-2.0.3/src/
tds_fdw-2.0.3/src/deparse.c=
tds_fdw-2.0.3/src/options.c=
tds_fdw-2.0.3/src/tds_fdw.c=
tds_fdw-2.0.3/tds_fdw.control
tds_fdw-2.0.3/tests/
tds_fdw-2.0.3/tests/.gitignore
tds_fdw-2.0.3/tests/README.md
tds_fdw-2.0.3/tests/lib/
tds_fdw-2.0.3/tests/lib/__init__.py
tds_fdw-2.0.3/tests/lib/messages.py
tds_fdw-2.0.3/tests/lib/tests.py
tds_fdw-2.0.3/tests/mssql-tests.py=
tds_fdw-2.0.3/tests/postgresql-tests.py
tds_fdw-2.0.3/tests/tests/<=
/pre>
tds_fdw-2.0.3/tests/tests/mssql/
tds_fdw-2.0.3/tests/tests/mssql/000_create_schema.js=
on
tds_fdw-2.0.3/tests/tests/mssql/000_create_schema.sq=
l
tds_fdw-2.0.3/tests/tests/mssql/001_create_tinyint_m=
in_table.json
tds_fdw-2.0.3/tests/tests/mssql/001_create_tinyint_m=
in_table.sql
tds_fdw-2.0.3/tests/tests/mssql/002_create_tinyint_m=
ax_table.json
tds_fdw-2.0.3/tests/tests/mssql/002_create_tinyint_m=
ax_table.sql
tds_fdw-2.0.3/tests/tests/mssql/003_create_smallint_=
min_table.json
tds_fdw-2.0.3/tests/tests/mssql/003_create_smallint_=
min_table.sql
tds_fdw-2.0.3/tests/tests/mssql/004_create_smallint_=
max_table.json
tds_fdw-2.0.3/tests/tests/mssql/004_create_smallint_=
max_table.sql
tds_fdw-2.0.3/tests/tests/mssql/005_create_int_min_t=
able.json
tds_fdw-2.0.3/tests/tests/mssql/005_create_int_min_t=
able.sql
tds_fdw-2.0.3/tests/tests/mssql/006_create_int_max_t=
able.json
tds_fdw-2.0.3/tests/tests/mssql/006_create_int_max_t=
able.sql
tds_fdw-2.0.3/tests/tests/mssql/007_create_bigint_mi=
n_table.json
tds_fdw-2.0.3/tests/tests/mssql/007_create_bigint_mi=
n_table.sql
tds_fdw-2.0.3/tests/tests/mssql/008_create_bigint_ma=
x_table.json
tds_fdw-2.0.3/tests/tests/mssql/008_create_bigint_ma=
x_table.sql
tds_fdw-2.0.3/tests/tests/mssql/009_create_decimal_t=
able.json
tds_fdw-2.0.3/tests/tests/mssql/009_create_decimal_t=
able.sql
tds_fdw-2.0.3/tests/tests/mssql/010_create_float4_ta=
ble.json
tds_fdw-2.0.3/tests/tests/mssql/010_create_float4_ta=
ble.sql
tds_fdw-2.0.3/tests/tests/mssql/011_create_float8_ta=
ble.json
tds_fdw-2.0.3/tests/tests/mssql/011_create_float8_ta=
ble.sql
tds_fdw-2.0.3/tests/tests/mssql/012_create_date_tabl=
e.json
tds_fdw-2.0.3/tests/tests/mssql/012_create_date_tabl=
e.sql
tds_fdw-2.0.3/tests/tests/mssql/013_create_time_tabl=
e.json
tds_fdw-2.0.3/tests/tests/mssql/013_create_time_tabl=
e.sql
tds_fdw-2.0.3/tests/tests/mssql/014_create_datetime_=
table.json
tds_fdw-2.0.3/tests/tests/mssql/014_create_datetime_=
table.sql
tds_fdw-2.0.3/tests/tests/mssql/015_create_datetime2=
_table.json
tds_fdw-2.0.3/tests/tests/mssql/015_create_datetime2=
_table.sql
tds_fdw-2.0.3/tests/tests/mssql/016_create_datetimeo=
ffset_table.json
tds_fdw-2.0.3/tests/tests/mssql/016_create_datetimeo=
ffset_table.sql
tds_fdw-2.0.3/tests/tests/mssql/017_create_char_tabl=
e.json
tds_fdw-2.0.3/tests/tests/mssql/017_create_char_tabl=
e.sql
tds_fdw-2.0.3/tests/tests/mssql/018_create_varchar_t=
able.json
tds_fdw-2.0.3/tests/tests/mssql/018_create_varchar_t=
able.sql
tds_fdw-2.0.3/tests/tests/mssql/019_create_varcharma=
x_table.json
tds_fdw-2.0.3/tests/tests/mssql/019_create_varcharma=
x_table.sql
tds_fdw-2.0.3/tests/tests/mssql/020_create_binary4_t=
able.json
tds_fdw-2.0.3/tests/tests/mssql/020_create_binary4_t=
able.sql
tds_fdw-2.0.3/tests/tests/mssql/021_create_varbinary=
4_table.json
tds_fdw-2.0.3/tests/tests/mssql/021_create_varbinary=
4_table.sql
tds_fdw-2.0.3/tests/tests/mssql/022_create_varbinary=
max_table.json
tds_fdw-2.0.3/tests/tests/mssql/022_create_varbinary=
max_table.sql
tds_fdw-2.0.3/tests/tests/mssql/023_create_null_date=
time_table.json
tds_fdw-2.0.3/tests/tests/mssql/023_create_null_date=
time_table.sql
tds_fdw-2.0.3/tests/tests/mssql/024_create_null_date=
time2_table.json
tds_fdw-2.0.3/tests/tests/mssql/024_create_null_date=
time2_table.sql
tds_fdw-2.0.3/tests/tests/mssql/025_create_match_col=
umn_table.json
tds_fdw-2.0.3/tests/tests/mssql/025_create_match_col=
umn_table.sql
tds_fdw-2.0.3/tests/tests/mssql/026_create_column_na=
me_table.json
tds_fdw-2.0.3/tests/tests/mssql/026_create_column_na=
me_table.sql
tds_fdw-2.0.3/tests/tests/mssql/027_create_query_opt=
ion_table.json
tds_fdw-2.0.3/tests/tests/mssql/027_create_query_opt=
ion_table.sql
tds_fdw-2.0.3/tests/tests/mssql/028_create_view_simp=
le_prerequisites.json
tds_fdw-2.0.3/tests/tests/mssql/028_create_view_simp=
le_prerequisites.sql
tds_fdw-2.0.3/tests/tests/mssql/029_create_view_simp=
le.json
tds_fdw-2.0.3/tests/tests/mssql/029_create_view_simp=
le.sql
tds_fdw-2.0.3/tests/tests/postgresql/
tds_fdw-2.0.3/tests/tests/postgresql/000_create_sche=
ma.json
tds_fdw-2.0.3/tests/tests/postgresql/000_create_sche=
ma.sql
tds_fdw-2.0.3/tests/tests/postgresql/001_create_serv=
er.json
tds_fdw-2.0.3/tests/tests/postgresql/001_create_serv=
er.sql
tds_fdw-2.0.3/tests/tests/postgresql/002_create_user=
_mapping.json
tds_fdw-2.0.3/tests/tests/postgresql/002_create_user=
_mapping.sql
tds_fdw-2.0.3/tests/tests/postgresql/003_import_sche=
ma.json
tds_fdw-2.0.3/tests/tests/postgresql/003_import_sche=
ma.sql
tds_fdw-2.0.3/tests/tests/postgresql/004_tinyintmin.=
json
tds_fdw-2.0.3/tests/tests/postgresql/004_tinyintmin.=
sql
tds_fdw-2.0.3/tests/tests/postgresql/005_tinyintmax.=
json
tds_fdw-2.0.3/tests/tests/postgresql/005_tinyintmax.=
sql
tds_fdw-2.0.3/tests/tests/postgresql/006_smallintmin=
.json
tds_fdw-2.0.3/tests/tests/postgresql/006_smallintmin=
.sql
tds_fdw-2.0.3/tests/tests/postgresql/007_smallintmax=
.json
tds_fdw-2.0.3/tests/tests/postgresql/007_smallintmax=
.sql
tds_fdw-2.0.3/tests/tests/postgresql/008_intmin.json=
tds_fdw-2.0.3/tests/tests/postgresql/008_intmin.sql<=
o:p>
tds_fdw-2.0.3/tests/tests/postgresql/009_intmax.json=
tds_fdw-2.0.3/tests/tests/postgresql/009_intmax.sql<=
o:p>
tds_fdw-2.0.3/tests/tests/postgresql/010_bigintmin.j=
son
tds_fdw-2.0.3/tests/tests/postgresql/010_bigintmin.s=
ql
tds_fdw-2.0.3/tests/tests/postgresql/011_bigintmax.j=
son
tds_fdw-2.0.3/tests/tests/postgresql/011_bigintmax.s=
ql
tds_fdw-2.0.3/tests/tests/postgresql/012_decimal.jso=
n
tds_fdw-2.0.3/tests/tests/postgresql/012_decimal.sql=
tds_fdw-2.0.3/tests/tests/postgresql/013_float4.json=
tds_fdw-2.0.3/tests/tests/postgresql/013_float4.sql<=
o:p>
tds_fdw-2.0.3/tests/tests/postgresql/014_float8.json=
tds_fdw-2.0.3/tests/tests/postgresql/014_float8.sql<=
o:p>
tds_fdw-2.0.3/tests/tests/postgresql/015_date.json
tds_fdw-2.0.3/tests/tests/postgresql/015_date.sql
tds_fdw-2.0.3/tests/tests/postgresql/016_time.json
tds_fdw-2.0.3/tests/tests/postgresql/016_time.sql
tds_fdw-2.0.3/tests/tests/postgresql/017_datetime.js=
on
tds_fdw-2.0.3/tests/tests/postgresql/017_datetime.sq=
l
tds_fdw-2.0.3/tests/tests/postgresql/018_datetime2.j=
son
tds_fdw-2.0.3/tests/tests/postgresql/018_datetime2.s=
ql
tds_fdw-2.0.3/tests/tests/postgresql/019_datetimeoff=
set.json
tds_fdw-2.0.3/tests/tests/postgresql/019_datetimeoff=
set.sql
tds_fdw-2.0.3/tests/tests/postgresql/020_char.json
tds_fdw-2.0.3/tests/tests/postgresql/020_char.sql
tds_fdw-2.0.3/tests/tests/postgresql/021_varchar.jso=
n
tds_fdw-2.0.3/tests/tests/postgresql/021_varchar.sql=
tds_fdw-2.0.3/tests/tests/postgresql/022_varcharmax.=
json
tds_fdw-2.0.3/tests/tests/postgresql/022_varcharmax.=
sql
tds_fdw-2.0.3/tests/tests/postgresql/023_binary4.jso=
n
tds_fdw-2.0.3/tests/tests/postgresql/023_binary4.sql=
tds_fdw-2.0.3/tests/tests/postgresql/024_varbinary4.=
json
tds_fdw-2.0.3/tests/tests/postgresql/024_varbinary4.=
sql
tds_fdw-2.0.3/tests/tests/postgresql/025_varbinaryma=
x.json
tds_fdw-2.0.3/tests/tests/postgresql/025_varbinaryma=
x.sql
tds_fdw-2.0.3/tests/tests/postgresql/026_null_dateti=
me.json
tds_fdw-2.0.3/tests/tests/postgresql/026_null_dateti=
me.sql
tds_fdw-2.0.3/tests/tests/postgresql/027_null_dateti=
me2.json
tds_fdw-2.0.3/tests/tests/postgresql/027_null_dateti=
me2.sql
tds_fdw-2.0.3/tests/tests/postgresql/028_column_matc=
h_enabled.json
tds_fdw-2.0.3/tests/tests/postgresql/028_column_matc=
h_enabled.sql
tds_fdw-2.0.3/tests/tests/postgresql/029_column_matc=
h_disabled.json
tds_fdw-2.0.3/tests/tests/postgresql/029_column_matc=
h_disabled.sql
tds_fdw-2.0.3/tests/tests/postgresql/030_column_name=
.json
tds_fdw-2.0.3/tests/tests/postgresql/030_column_name=
.sql
tds_fdw-2.0.3/tests/tests/postgresql/031_query_optio=
n_column_match_enabled.json
tds_fdw-2.0.3/tests/tests/postgresql/031_query_optio=
n_column_match_enabled.sql
tds_fdw-2.0.3/tests/tests/postgresql/032_query_optio=
n_column_match_disabled.json
tds_fdw-2.0.3/tests/tests/postgresql/032_query_optio=
n_column_match_disabled.sql
tds_fdw-2.0.3/tests/tests/postgresql/033_view_simple=
.json
tds_fdw-2.0.3/tests/tests/postgresql/033_view_simple=
.sql
tds_fdw-2.0.3/tests/tests/postgresql/034_explain.jso=
n
tds_fdw-2.0.3/tests/tests/postgresql/034_explain.sql=
tds_fdw-2.0.3/tests/tests/postgresql/035_rescan.json=
tds_fdw-2.0.3/tests/tests/postgresql/035_rescan.sql<=
o:p>
tds_fdw-2.0.3/tests/validate-test-json
[root@hostip ~]#
[root@hostip ~]# cd tds_fdw-${TDS_FDW_VERSION}<=
/o:p>
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]# PATH=3D/usr/edb/as13/bi=
n:$PATH
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]# make USE_PGXS=3D1<=
/o:p>
gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointe=
r-arith -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels -Wmissin=
g-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-=
precision=3Dstandard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -=
Wp,-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protector-strong --param=3Dss=
p-buffer-size=3D4 -grecord-gcc-switches   -m64 -mtune=3Dgeneric -=
fPIC -I./include/ -fvisibility=3Dhidden  -I. -I./ -I/usr/edb/as13/incl=
ude/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/includ=
e/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o sr=
c/tds_fdw.o src/tds_fdw.c
 
gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointe=
r-arith -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels -Wmissin=
g-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-=
precision=3Dstandard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -=
Wp,-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protector-strong --param=3Dss=
p-buffer-size=3D4 -grecord-gcc-switches   -m64 -mtune=3Dgeneric -=
fPIC -I./include/ -fvisibility=3Dhidden  -I. -I./ -I/usr/edb/as13/incl=
ude/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/includ=
e/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o sr=
c/options.o src/options.c
gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointe=
r-arith -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels -Wmissin=
g-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-=
precision=3Dstandard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -=
Wp,-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protector-strong --param=3Dss=
p-buffer-size=3D4 -grecord-gcc-switches   -m64 -mtune=3Dgeneric -=
fPIC -I./include/ -fvisibility=3Dhidden  -I. -I./ -I/usr/edb/as13/incl=
ude/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/includ=
e/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o sr=
c/deparse.o src/deparse.c
gcc -std=3Dgnu99 -Wall -Wmissing-prototypes -Wpointe=
r-arith -Wdeclaration-after-statement -Werror=3Dvla -Wendif-labels -Wmissin=
g-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-=
precision=3Dstandard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -=
Wp,-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protector-strong --param=3Dss=
p-buffer-size=3D4 -grecord-gcc-switches   -m64 -mtune=3Dgeneric -=
fPIC -shared -o tds_fdw.so src/tds_fdw.o src/options.o src/deparse.o -L/usr=
/edb/as13/lib  -L/usr/libexec/edb-icu66/lib/  -L/usr/lib64/llvm5.=
0/lib  -L/usr/lib64 -Wl,--as-needed -Wl,-rpath,'/usr/edb/as13/lib',--e=
nable-new-dtags  -lsybdb
cp sql/tds_fdw.sql sql/tds_fdw--2.0.3.sql=
cp README.md README.tds_fdw.md
/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignor=
ed-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argumen=
t -O2  -I./include/ -fvisibility=3Dhidden  -I. -I./ -I/usr/edb/as=
13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66=
/include/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include -flto=
=3Dthin -emit-llvm -c -o src/tds_fdw.bc src/tds_fdw.c
make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Com=
mand not found
make: *** [src/tds_fdw.bc] Error 127
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]# PATH=3D/usr/edb/as13/bi=
n:$PATH
[root@hostip tds_fdw-2.0.3]# make USE_PGXS=3D1 insta=
ll
/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignor=
ed-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argumen=
t -O2  -I./include/ -fvisibility=3Dhidden  -I. -I./ -I/usr/edb/as=
13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66=
/include/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include -flto=
=3Dthin -emit-llvm -c -o src/tds_fdw.bc src/tds_fdw.c
make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Com=
mand not found
make: *** [src/tds_fdw.bc] Error 127
[root@hostip tds_fdw-2.0.3]#

 

 

CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for= the use of the intended recipient and may contain information that is priv= ileged, confidential or exempt from disclosure under applicable law. If you= are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attach= ments is prohibited. If you have received this e-mail message in error, ple= ase delete and notify the sender immediately. Thank you. --_000_PH7PR14MB53674648EB083CD246900B65F9F12PH7PR14MB5367namp_--