Re: Regarding Tds_fdw

[Durgamahesh Manne <maheshpostgres9@xxxxxxxxx>]

On Wed, Nov 28, 2018 at 4:22 PM Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:

Hi

st 28. 11. 2018 v 11:28 odesílatel Durgamahesh Manne <maheshpostgres9@xxxxxxxxx> napsal:

Hi 

Respected community members

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 ?

I can read on page https://support.google.com/hangouts/answer/3110347?hl=en&ref_topic=2944918&vid=0-737329123936-1543400907610

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

Regards

Pavel

 

Regards

durgamahesh manne

 Hi 

are there any fdw which supports dml operation on  sql server foreign tables i have created in pg server ?

Regards