Postgres 10 TDS_FDW extension undefined symbol: Float4GetDatum

Question

I'm trying to add the tds fdw extension to a new installation of Postgres 10 on CentOS. I've run make/install for the tds_fdw, but when attempting to

CREATE EXTENSION tds_fdw;

from PG Admin it fails with the message:

ERROR: could not load library "/usr/pgsql-10/lib/tds_fdw.so": /usr/pgsql-10/lib/tds_fdw.so: undefined symbol: Float4GetDatum
SQL state: XX000

I'm new to CentOS and building anything postgres related. Thanks in advance.

Answer 1

This sounds like the PostgreSQL for which you built the extension is configured in a different way than the one where you try to run it.

The obvious cause would be if the one for which you built tds_fdw was configured with --disable-float4-byval.