Thread: Foreign Data Wrapper
Hello ,
I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. Foreign table has been created with data. unfortunately I am unable to perform DML operation like insert, update and delete on foreign table. Whenever I tried to perform DML operation on foreign table we are getting error i.e. “ERROR: cannot insert into foreign table "test12" SQL state: 0A000”
Kindly give me response soon because I am stuck at the middle of the project.
Thanks, Virendra Shaktawat T / +91 (0) 9099907116
| |||||||
| |||||||
Disclaimer This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message. |
Attachment
Hello ,
I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. Foreign table has been created with data. unfortunately I am unable to perform DML operation like insert, update and delete on foreign table. Whenever I tried to perform DML operation on foreign table we are getting error i.e. “ERROR: cannot insert into foreign table "test12"
SQL state: 0A000”
Kindly give me response soon because I am stuck at the middle of the project.
Thanks,
Virendra Shaktawat
Database Developer
R&D .Net DepartmentT / +91 (0) 9099907116
virendra.shaktawat@ / www.quipment.in
QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail@ / www.quipment.nlHoofdkantoor Nijmegen
Kerkenbos 1236 C
6546 BE Nijmegen
Tel.
+31 (0)24 372 47 00
Fax.
+31 (0)24 372 47 07
Quipment India
903-904 Landmark,
Beside Titanium City Centre,
Anandnagar Road, 100ft Ring Road,
Ahmedabad
Gujarat - 380015 - India
Tel. +91 (0) 79 4009 7847Disclaimer
This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message.
Attachment
Hi Atri,
odbc_fdw
Regards,
Virendra Shaktawat
Database Developer
R&D .Net Department
T / +91 (0) 90999 07116
virendra.shaktawat@ / www.quipment.in
From: Atri Sharma [mailto:atri.jiit@gmail.com]
Sent: 21 December 2017 06:21 PM
To: Virendra Shaktawat - Quipment India <virendra.shaktawat@quipment.nl>
Cc: pgsql-general@postgresql.org
Subject: Re: Foreign Data Wrapper
Which FDW?
On Thu, Dec 21, 2017 at 5:54 PM, Virendra Shaktawat - Quipment India <virendra.shaktawat@quipment.nl> wrote:
Hello ,
I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. Foreign table has been created with data. unfortunately I am unable to perform DML operation like insert, update and delete on foreign table. Whenever I tried to perform DML operation on foreign table we are getting error i.e. “ERROR: cannot insert into foreign table "test12"
SQL state: 0A000”
Kindly give me response soon because I am stuck at the middle of the project.
Thanks,
Virendra Shaktawat
Database Developer
R&D .Net DepartmentT / +91 (0) 9099907116
virendra.shaktawat@ / www.quipment.in
QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail@ / www.quipment.nlHoofdkantoor Nijmegen
Kerkenbos 1236 C
6546 BE Nijmegen
Tel.
+31 (0)24 372 47 00
Fax.
+31 (0)24 372 47 07
Quipment India
903-904 Landmark,
Beside Titanium City Centre,
Anandnagar Road, 100ft Ring Road,
Ahmedabad
Gujarat - 380015 - India
Tel. +91 (0) 79 4009 7847Disclaimer
This e-mail message (including any attachment) is intended only for the personal use of the recipient(s) named above. This message is confidential and may be legally privileged. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message.
--
Regards,
Atri
l'apprenant
Attachment
odbc_fdw
please don't top post, and please don't use graphics and HTML in your email, this is a text based mailling list adhering to bottom/interleaved posting standards.
While I'm not directly familiar with odbc_fdw, I suspect its a 'read only' FDW
is that this odbc_fdw? https://github.com/ZhengYang/odbc_fdw
that was developed for pg 9.1 when ALL fdw's were read only as it was brand new technology. since this defines the foreign table via a query, well, there's no WAY it could be used to do an update.
this updated fork, https://github.com/CartoDB/odbc_fdw runs on newer postgres, but also is based on a select statement, you can't UPDATE a resultset...
-- john r pierce, recycling bits in santa cruz
Le 21 déc. 2017 à 13:24, Virendra Shaktawat - Quipment India écrivait : > Quipment Logo > > Hello , > > > > I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. > Foreign table has been created with data. unfortunately I am unable to perform > DML operation like insert, update and delete on foreign table. Whenever I tried > to perform DML operation on foreign table we are getting error i.e. “ERROR: > cannot insert into foreign table "test12" > > SQL state: 0A000” > > > > Kindly give me response soon because I am stuck at the middle of the project. > > Hi, I would give a try to a specific MSSQL FDW such: https://www.openscg.com/bigsql/docs/tds_fdw/ and the github: https://github.com/tds-fdw/tds_fdw While insert is not yet available there apparently some work have already been done and could be improved https://github.com/tds-fdw/tds_fdw/issues/9
On Thu, Dec 21, 2017 at 12:24:25PM +0000, Virendra Shaktawat - Quipment India wrote: > [Quipment Logo] > I have stuck at foreign data wrapper. I am accessing the form MS Sql Server. Foreign table has been created with data.unfortunately I am unable to perform DML operation like insert, update and delete on foreign table. Whenever I triedto perform DML operation on foreign table we are getting error i.e. "ERROR: cannot insert into foreign table "test12" > SQL state: 0A000" You may want to see directly with the maintainers of the FDW you are using for remote access. That's up to each FDW to use the set of APIs PostgreSQL provides, and to support them when they come out. -- Michael