search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
377 stars 101 forks source link

IMPORT FOREIGN SCHEMA issue #114

Open ced75 opened 7 years ago

ced75 commented 7 years ago

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 commented 7 years ago

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

neilmcguigan commented 7 years ago

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 commented 6 years ago

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

thatguypark commented 6 years ago

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.