Thread: Regarding Tds_fdw
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 ?
Regards
durgamahesh manne
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:
HiRespected community membersI 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 issuesi got this error ERROR: cannot insert into foreign table "pgsql" when i tried to insert the data into foerign table1) 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
Regardsdurgamahesh manne
On Wed, Nov 28, 2018 at 4:22 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hist 28. 11. 2018 v 11:28 odesílatel Durgamahesh Manne <maheshpostgres9@gmail.com> napsal:HiRespected community membersI 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 issuesi got this error ERROR: cannot insert into foreign table "pgsql" when i tried to insert the data into foerign table1) 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."RegardsPavelRegardsdurgamahesh 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:
On Wed, Nov 28, 2018 at 4:22 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:Hist 28. 11. 2018 v 11:28 odesílatel Durgamahesh Manne <maheshpostgres9@gmail.com> napsal:HiRespected community membersI 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 issuesi got this error ERROR: cannot insert into foreign table "pgsql" when i tried to insert the data into foerign table1) 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."RegardsPavelRegardsdurgamahesh manneHiare there any fdws which supports dml operation on sql server foreign tables i have created in pg server ?Regards