Обсуждение: Foreign Data Wrapper

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