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.



Reply via email to