Date: Wed, 27 Sep 2017 16:55:23 +0200
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
Message-ID: <20170927145523.dfv5wzjqix7chrf6@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CA+Mn-VZy66cY9kvK3LUstwFsyp7y83boVD8a2=itiYnGpGwg5A@mail.gmail.com>
User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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