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.