santanab

Support for PostgreSQL 9.5's IMPORT FOREIGN SCHEMA

1

I currently use JDBC_FDW with PostgreSQL 9.3 and db2, and works perfect, but with the Postgresql 9.5's new feature "IMPORT FOREIGN SCHEMA", after compile jdbc_fdw for work with that version...

# CREATE FOREIGN TABLE b (process_date char(9)) server jdbc_as4002 options (query 'SELECT R FROM schema.table'); ERROR: invalid option "query" HINT: Valid options in this context are: use_remote_estimate, updatable, schema_name, table_name,...

create extension odbc_fdw on Postgresql 9.3.9: Centos.

1

ERROR: could not access file "$libdir/odbc_fdw": No such file or directory How can I solve it? Thanks.