IMPORT FOREIGN SCHEMA issue

[ced75]

Hi,

I am connecting to a SQL Server 2000 database with the last master version of tds_fdw. My PostgreSQL server is in 9.6.1 version.

I have compiled without any problem the master version. I have created the foreign server as followed: CREATE SERVER ms_srv FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername 'sql2000.mydomain.fr', port '1433', database 'Cible');

Then I have created a user mapping which is also OK.

If I create a foreign table, it works fine.

But, when I try to import a foreign schema like this: IMPORT FOREIGN SCHEMA dbo EXCEPT (mssql_table) FROM SERVER ms_srv INTO public OPTIONS (import_default 'true'); I get the following error: "le wrapper de données distantes « tds_fdw » ne supporte pas IMPORT FOREIGN SCHEMA" meaning that tds_fdw does not support IMPORT FOREIGN SCHEMA.

But the master version supports it? What am I doing wrong?

Thanks in advance for your help. Regards,

Cedric

[denishpatel]

@ced75 I'm having same issue. have you found the fix?

[neilmcguigan]

I get: ERROR: foreign-data wrapper "tds_fdw" does not support IMPORT FOREIGN SCHEMA

tds_fdw version 1.0.8 on PostgreSQL 9.6.5 on CentOS 6.5 64-bit

[sxagan]

@neilmcguigan I encountered the same problem. Probably because of the PostgreSQL version

[thatguypark]

You will have to use the current 2.0.0-alpha/beta release, I found that the 1.0.8 version didn't yet have the support.