Foreign Data Wrapper

Which FDW?

On Thu, Dec 21, 2017 at 5:54 PM, Virendra Shaktawat - Quipment India <
virendra.shaktawat@quipment.nl> wrote:

[image: 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.

Thanks,

*Virendra Shaktawat*
*Database Developer*

R&D .Net Department

T / +91 (0) 9099907116 <+91%2090999%2007116>
virendra.shaktawat@ <%20virendra.shaktawat@quipment.in> / www.quipment.in

*QTwee Group BV*
KvK Arnhem 60858001
BTW NL854090721B01
mail@ <mail@quipment.nl> / www.quipment.nl

*Hoofdkantoor Nijmegen
<https://maps.google.com/?q=Nijmegen+%0D+Kerkenbos+1236+C+%0D+6546+BE&amp;entry=gmail&amp;source=g&gt;*
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 7847 <+91%2079%204009%207847>

*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.

--
Regards,

Atri
*l'apprenant*

Hi Atri,

odbc_fdw

Regards,
Virendra Shaktawat
Database Developer

R&D .Net Department
T / +91 (0) 90999 07116
virendra.shaktawat@ / www.quipment.in<http://www.quipment.in/&gt;

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<mailto:virendra.shaktawat@quipment.nl>> wrote:
[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.

Thanks,

Virendra Shaktawat
Database Developer

R&D .Net Department

T / +91 (0) 9099907116<tel:+91%2090999%2007116>
virendra.shaktawat@<mailto:%20virendra.shaktawat@quipment.in> / www.quipment.in<http://www.quipment.in&gt;

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail@<mailto:mail@quipment.nl> / www.quipment.nl<http://www.quipment.nl&gt;

Hoofdkantoor Nijmegen<https://maps.google.com/?q=Nijmegen+%0D+Kerkenbos+1236+C+%0D+6546+BE&amp;entry=gmail&amp;source=g&gt;
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 7847<tel:+91%2079%204009%207847>

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.

--
Regards,

Atri
l'apprenant

On 12/21/2017 5:14 AM, Virendra Shaktawat - Quipment India wrote:

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 tried to 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