Foreign Data Wrapper

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Foreign Data Wrapper

Virendra Shaktawat - Quipment India

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
[hidden email] / www.quipment.in

 

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
[hidden email] / www.quipment.nl

Hoofdkantoor 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 7847

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.

 

Reply | Threaded
Open this post in threaded view
|

Re: Foreign Data Wrapper

Atri Sharma
Which FDW?



On Thu, Dec 21, 2017 at 5:54 PM, Virendra Shaktawat - Quipment India <[hidden email]> 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 / <a href="tel:+91%2090999%2007116" value="+919099907116" target="_blank">+91 (0) 9099907116
[hidden email] / www.quipment.in

 

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
[hidden email] / www.quipment.nl

Hoofdkantoor 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. <a href="tel:+91%2079%204009%207847" value="+917940097847" target="_blank">+91 (0) 79 4009 7847

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
Reply | Threaded
Open this post in threaded view
|

RE: Foreign Data Wrapper

Virendra Shaktawat - Quipment India

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:[hidden email]]
Sent: 21 December 2017 06:21 PM
To: Virendra Shaktawat - Quipment India <[hidden email]>
Cc: [hidden email]
Subject: Re: Foreign Data Wrapper

 

Which FDW?

 

 

 

On Thu, Dec 21, 2017 at 5:54 PM, Virendra Shaktawat - Quipment India <[hidden email]> 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 / <a href="tel:&#43;91%2090999%2007116" target="_blank"> +91 (0) 9099907116
[hidden email] / www.quipment.in

 

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
[hidden email] / www.quipment.nl

Hoofdkantoor <a href="https://maps.google.com/?q=Nijmegen&#43;%0D&#43;Kerkenbos&#43;1236&#43;C&#43;%0D&#43;6546&#43;BE&amp;entry=gmail&amp;source=g"> 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. <a href="tel:&#43;91%2079%204009%207847" target="_blank">+91 (0) 79 4009 7847

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

Reply | Threaded
Open this post in threaded view
|

Re: Foreign Data Wrapper

John R Pierce
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
Reply | Threaded
Open this post in threaded view
|

Re: Foreign Data Wrapper

Nicolas Paris
In reply to this post by Virendra Shaktawat - Quipment India
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

Reply | Threaded
Open this post in threaded view
|

Re: Foreign Data Wrapper

Michael Paquier
In reply to this post by Virendra Shaktawat - Quipment India
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

signature.asc (849 bytes) Download Attachment