Regarding Tds_fdw

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.

Hi

st 28. 11. 2018 v 11:28 odesílatel Durgamahesh Manne <
maheshpostgres9@gmail.com> 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&amp;ref_topic=2944918&amp;vid=0-737329123936-1543400907610

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

Regards

Pavel

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

Hi

st 28. 11. 2018 v 11:28 odesílatel Durgamahesh Manne <
maheshpostgres9@gmail.com> 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&amp;ref_topic=2944918&amp;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

On Wed, Nov 28, 2018 at 6:31 PM Durgamahesh Manne <maheshpostgres9@gmail.com>
wrote: