Re: Regarding Tds_fdw - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Regarding Tds_fdw
Date
Msg-id 3011f815-48e4-b57c-668d-dc8f618e0294@gmx.net
Whole thread Raw
In response to Regarding Tds_fdw  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
List pgsql-general
Durgamahesh Manne schrieb am 28.11.2018 um 11:28:
> I have configured tds_fdw on postgres server.. I have created
> multiple foreign tables related to sql server as of now i could run
> select queries with out any issues
> 
>   i got  this error ERROR: cannot insert into foreign table "pgsql"  when i tried to insert the data into foerign
table 
> 
> 1) Is there any way to run insert delete update  queries on foreign tables ?

The TDS FDW currently does currently not support write operations:

Quote from https://github.com/tds-fdw/tds_fdw

   The current version does not yet support JOIN push-down, or write operations.




pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Regarding Tds_fdw
Next
From: Pavel Stehule
Date:
Subject: Re: Regarding Tds_fdw