Select on Foreign table is not working

From: Sahil Khan <ksahil0258(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Select on Foreign table is not working
Date: 2023-01-11 08:12:53
Message-ID: CAHgsOX8VO5X9C5U4-U3buJPazGdqsVZQfJ7BEKpobWcJ8gToag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2023-01-11 08:37:48 Re: Select on Foreign table is not working
Previous Message David G. Johnston 2023-01-09 23:58:09 Re: csv vs json?