MIME-Version: 1.0
References: <PH7PR14MB53674648EB083CD246900B65F9F12@PH7PR14MB5367.namprd14.prod.outlook.com>
In-Reply-To: <PH7PR14MB53674648EB083CD246900B65F9F12@PH7PR14MB5367.namprd14.prod.outlook.com>
From: Ian Lawrence Barwick <barwick@gmail.com>
Date: Wed, 29 May 2024 09:27:30 +0900
Message-ID: <CAB8KJ=jpbREGEPVXX0x4X01de8dd3jiOzunc5x3bYxfRTLSdXg@mail.gmail.com>
Subject: Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to
 connect to SQL server database
To: Sumit Kochar <Sumit.Kochar@mastercard.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAB8KJ%3DjpbREGEPVXX0x4X01de8dd3jiOzunc5x3bYxfRTLSdXg%40mail.gmail.com>
Precedence: bulk

2024=E5=B9=B45=E6=9C=8829=E6=97=A5(=E6=B0=B4) 6:10 Sumit Kochar <Sumit.Koch=
ar@mastercard.com>:
>
> Installation of Foreign data Wrapper on EDB Postgres to connect to SQL se=
rver 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.
(...)

> [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-st=
rict-aliasing -fwrapv -Wno-unused-command-line-argument -O2  -I./include/ -=
fvisibility=3Dhidden  -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as=
13/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.b=
c src/tds_fdw.c
>
> make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

IIRC you'll need to find and install the SCLO package for Oracle Linux
7, assuming it's
available. For CentOS it's this repository:
http://mirror.centos.org/centos/7/sclo/ .

Regards

Ian Barwick