From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Carlos Martinez <camarti@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: dblink_tds or similar for PostgreSQL 10
Date: Wed, 27 Sep 2017 16:55:23 +0200
Message-ID: <20170927145523.dfv5wzjqix7chrf6@alvherre.pgsql> (raw)
In-Reply-To: <CA+Mn-VZy66cY9kvK3LUstwFsyp7y83boVD8a2=itiYnGpGwg5A@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Carlos Martinez wrote:
> Hi.
>
> I know that Postgres 10 is not yet stable. The migration will take
> around 3 or 4 months. I will expect by then, the stable version.
> I've reading about FDW and tds_fdw (library for MS SQL), but it says:
> "The current version does not yet support WHERE clause push-down,
> column push-down, JOIN push-down, or write operations."
In other words, you have 3-4 months to poke the tds_fdw maintainer to
add support for that (or do it yourself, or convince someone else to do
it for you).
> Sadly, I need to do a INSERT on MS SQL.
You should be happy that you're using the most advanced relational open
source database server in the world, not sad.
cheers
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: alvherre@alvh.no-ip.org, camarti@gmail.com
Subject: Re: dblink_tds or similar for PostgreSQL 10
In-Reply-To: <20170927145523.dfv5wzjqix7chrf6@alvherre.pgsql>
* 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