From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Select on Foreign table is not working
Date: Wed, 11 Jan 2023 09:37:48 +0100
Message-ID: <82da1091-ef02-ed31-06ea-158eaaaf1ed2@jakobs.com> (raw)
In-Reply-To: <CAHgsOX8VO5X9C5U4-U3buJPazGdqsVZQfJ7BEKpobWcJ8gToag@mail.gmail.com>
References: <CAHgsOX8VO5X9C5U4-U3buJPazGdqsVZQfJ7BEKpobWcJ8gToag@mail.gmail.com>
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
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../82da1091-ef02-ed31-06ea-158eaaaf1ed2@jakobs.com/3-OpenPGP_signature)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Select on Foreign table is not working
In-Reply-To: <82da1091-ef02-ed31-06ea-158eaaaf1ed2@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox