Re: Select on Foreign table is not working

Am 11.01.23 um 09:12 schrieb Sahil Khan:
> Hi,
>
> Hope you are doing well,
>
> I have created a foreign table on my postgresql server to select the
> data on external table which is reside on MS SQL Server, everything
> went well from installing to freetds and installing and configuring
> tds_fdw tool, and created foreign server and user mapping then created
> foreign table, but when i do select from table_name then it throws an
> error which is i mentioned below as.
>
> ERROR:  DB-Library error: DB #: 20018, DB Msg: General SQL Server
> error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 16
>
>
> will be highly grateful for your valuable suggestions, where to look
> for to get this done.
>
> Thank You.
>
> Regards,
> Sahil | +919892569610

I would suggest to do as the message says:

*Check messages from the SQL Server*

So, the log on the foreign server should have more information, which
isn't forwarded to PostgreSQL:

Kind Regards,
Holger

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012