jdbc2_fdw
jdbc2_fdw copied to clipboard
JDBC Foreign Data Wrapper for PostgreSQL
Hello! I have the following issue with PostgreSQL 9.6 and 10: ``` $ make USE_PGXS=1 jdbc2_fdw.c: In function ‘jdbcGetForeignRelSize’: jdbc2_fdw.c:469:36: error: ‘RelOptInfo {aka struct RelOptInfo}’ has no member named ‘reltargetlist’...
See https://gist.github.com/mc-soi/7201e5627573646b4f60 for my patch. The postgresPlanForeignModify code came from the postgresql_fdw code: http://doxygen.postgresql.org/postgres__fdw_8c.html#a64110f3b69e0af04ed7b8b614918c9c9 Some of the FDW API changes were in this commit: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1a8a4e5cde2b7755e11bde2ea7897bd650622d3e#patch14 So far, I have only...
Hello We have a build problem with jdbc2_fdw and PostgreSQL 9.5 After added patch https://github.com/heimir-sverrisson/jdbc2_fdw/issues/1 we get this(below), some of it is in swedish but hopefully easy to understand sh-4.1#...
After installing JDBC2_FDW and configuring for Teradata I am getting below error message while trying to run select \* from tbltd; I am able to create user mapping and foreign...
Hi Heimir, I have successfully compiled jdbc2_fdw, but when I tried to create extension within postgres postgres=# CREATE EXTENSION jdbc2_fdw; ERROR: incompatible library "/usr/local/pgsql/lib/jdbc2_fdw.so": magic block mismatch DETAIL: Server has...
Hi, I was able to install this and create the extension successfully, but when I try to do a simple select statement against my table I get the following error:...
# 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,...