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
