Re: 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