Issue report

The following information is very important in order to help us to help you. Omission of the following details cause delays or could receive no attention at all.

Operating system

On recent GNU/Linux distributions, you can provide the content of the file /etc/os-release

NAME="Oracle Linux Server"
VERSION="7.9"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.9"
PRETTY_NAME="Oracle Linux Server 7.9"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:9:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://github.com/oracle/oracle-linux"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.9
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.9

Version of tds_fdw

From a psql session, paste the outputs of running \dx

If you built the package from Git sources, also paste the output of running git log --source -n 1 on your git clone from a console

postgres=# \dx
                                  List of installed extensions
       Name       | Version |   Schema   |                     Description
------------------+---------+------------+------------------------------------------------------
 edb_dblink_libpq | 1.0     | pg_catalog | EnterpriseDB Foreign Data Wrapper for PostgreSQL
 edb_dblink_oci   | 1.0     | pg_catalog | EnterpriseDB Foreign Data Wrapper for Oracle
 edbspl           | 1.0     | pg_catalog | EDB-SPL procedural language
 pldbgapi         | 1.1     | pg_catalog | server-side support for debugging PL/pgSQL functions
 plpgsql          | 1.0     | pg_catalog | PL/pgSQL procedural language
(5 rows)

Version of PostgreSQL

From a psql session, paste the output of running SELECT version();

postgres=# SELECT version();
                                                                     version
--------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 13.13 (EnterpriseDB Advanced Server 13.13.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)

Version of FreeTDS

How to get it will depend on your Operating System and how you installes FreeTDS

From a console:

On RPM based systems: rpm -qa|grep freetds
On Deb based systems: dpkg -l|grep freetds
_If you built your own binaries from source code, then go to the sources, and run: grep 'AC_INIT' configure.ac_

freetds-devel-1.3.3-1.el7.x86_64
freetds-1.3.3-1.el7.x86_64
freetds-libs-1.3.3-1.el7.x86_64

Logs

Please capture the logs when the error you are reporting is happening, as well as commands with their outputs if you are reporting a problem build or installing

_For problems using tdsfdw on PostgreSQL how to do it will depend on your system, but if your PostgreSQL is installed on GNU/Linux, you will want to use tail -f with the log of the PostgreSQL cluster

For MSSQL you will need to use the SQL Server Audit Log

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 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="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=/usr/edb/as13/bin:$PATH 
make USE_PGXS=1 
PATH=/usr/edb/as13/bin:$PATH 
make USE_PGXS=1 install

Logs:

[root@hostip ~]# yum install install edb-as13-server edb-as13-server-libs edb-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 configuration\
Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\
Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\
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 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-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 configuration\
Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\
Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\
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 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-analyzer 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\
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 configuration\
Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\
Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\
**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="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/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’

    [ <=>                                                                                                                                                                                                                ] 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
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=/usr/edb/as13/bin:$PATH
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1
gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -fPIC -I./include/ -fvisibility=hidden  -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/include/libxml2  -I/usr/include  -c -o src/tds_fdw.o src/tds_fdw.c

gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -fPIC -I./include/ -fvisibility=hidden  -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/include/libxml2  -I/usr/include  -c -o src/options.o src/options.c
gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -fPIC -I./include/ -fvisibility=hidden  -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/include/libxml2  -I/usr/include  -c -o src/deparse.o src/deparse.c
gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -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',--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-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2  -I./include/ -fvisibility=hidden  -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/include/libxml2  -I/usr/include -flto=thin -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=/usr/edb/as13/bin:$PATH
[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1 install
/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2  -I./include/ -fvisibility=hidden  -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/include/libxml2  -I/usr/include -flto=thin -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]#

Sentences, data structures, data

This will depend on the exact problem you are having and data privacy restrictions

However the more data you provide, the more likely we will be able to help

As a bare minimum, you should provide

The SQL sentence that is failing
The data structure on the PostgreSQL side and on the MSSQL side

Replace this with the SQL sentences, data structures, etc

tds-fdw / tds_fdw

Install Foreign data Wrapper on EDB Postgres to connect to SQL server database #357