Re: Foreign Data Wrapper

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Virendra Shaktawat - Quipment India <virendra(dot)shaktawat(at)quipment(dot)nl>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Foreign Data Wrapper
Date: 2017-12-22 01:38:37
Message-ID: 20171222013837.GB11060@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Dec 21, 2017 at 12:24:25PM +0000, Virendra Shaktawat - Quipment India wrote:
> [Quipment Logo]
> I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. Foreign table has been created with data. unfortunately I am unable to perform DML operation like insert, update and delete on foreign table. Whenever I tried to perform DML operation on foreign table we are getting error i.e. "ERROR: cannot insert into foreign table "test12"
> SQL state: 0A000"

You may want to see directly with the maintainers of the FDW you are using
for remote access. That's up to each FDW to use the set of APIs PostgreSQL
provides, and to support them when they come out.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-12-22 02:34:48 Re: Intersection or zero-column queries
Previous Message David G. Johnston 2017-12-22 00:13:07 Re: Intersection or zero-column queries