On 12/21/2017 5:14 AM, Virendra Shaktawat - Quipment India wrote:
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