~ sudo USE_PGXS=1 pgxn install JDBC_FDW
INFO: best version: jdbc_fdw 1.0.0
INFO: saving /tmp/tmp8qwZCq/jdbc_fdw-1.0.0.zip
INFO: unpacking: /tmp/tmp8qwZCq/jdbc_fdw-1.0.0.zip
INFO: building extension
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -I/usr/include/mit-krb5 -fPIC -pie -fno-omit-frame-pointer -fPIC -D'PKG_LIB_DIR=/usr/local/pgsql/lib' -I. -I./ -I/usr/include/postgresql/server -I/usr/include/postgresql/internal -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/tcl8.6 -I/usr/include/x86_64-linux-gnu -c -o jdbc_fdw.o jdbc_fdw.c
jdbc_fdw.c: In function ‘jdbc_fdw_handler’:
jdbc_fdw.c:1060:66: error: incompatible type for argument 3 of ‘create_foreignscan_path’
add_path(baserel, (Path*)create_foreignscan_path(root, baserel, baserel->rows, startup_cost, total_cost, NIL, NULL, NIL));
^
In file included from jdbc_fdw.c:43:0:
/usr/include/postgresql/server/optimizer/pathnode.h:107:21: note: expected ‘PathTarget * {aka struct PathTarget *}’ but argument is of type ‘double’
extern ForeignPath *create_foreignscan_path(PlannerInfo *root, RelOptInfo *rel,
^
In file included from /usr/include/postgresql/server/access/tupdesc.h:19:0,
from /usr/include/postgresql/server/funcapi.h:20,
from jdbc_fdw.c:23:
/usr/include/postgresql/server/nodes/pg_list.h:69:18: error: incompatible type for argument 6 of ‘create_foreignscan_path’
#define NIL ((List *) NULL)
^
jdbc_fdw.c:1060:107: note: in expansion of macro ‘NIL’
add_path(baserel, (Path*)create_foreignscan_path(root, baserel, baserel->rows, startup_cost, total_cost, NIL, NULL, NIL));
^
In file included from jdbc_fdw.c:43:0:
/usr/include/postgresql/server/optimizer/pathnode.h:107:21: note: expected ‘Cost {aka double}’ but argument is of type ‘List * {aka struct List *}’
extern ForeignPath *create_foreignscan_path(PlannerInfo *root, RelOptInfo *rel,
^
In file included from /usr/include/postgresql/server/access/tupdesc.h:19:0,
from /usr/include/postgresql/server/funcapi.h:20,
from jdbc_fdw.c:23:
/usr/include/postgresql/server/nodes/pg_list.h:69:18: warning: passing argument 8 of ‘create_foreignscan_path’ from incompatible pointer type [-Wincompatible-pointer-types]
#define NIL ((List *) NULL)
^
jdbc_fdw.c:1060:118: note: in expansion of macro ‘NIL’
add_path(baserel, (Path*)create_foreignscan_path(root, baserel, baserel->rows, startup_cost, total_cost, NIL, NULL, NIL));
^
In file included from jdbc_fdw.c:43:0:
/usr/include/postgresql/server/optimizer/pathnode.h:107:21: note: expected ‘Relids {aka struct Bitmapset *}’ but argument is of type ‘List * {aka struct List *}’
extern ForeignPath *create_foreignscan_path(PlannerInfo *root, RelOptInfo *rel,
^
jdbc_fdw.c:1060:27: error: too few arguments to function ‘create_foreignscan_path’
add_path(baserel, (Path*)create_foreignscan_path(root, baserel, baserel->rows, startup_cost, total_cost, NIL, NULL, NIL));
^
In file included from jdbc_fdw.c:43:0:
/usr/include/postgresql/server/optimizer/pathnode.h:107:21: note: declared here
extern ForeignPath *create_foreignscan_path(PlannerInfo *root, RelOptInfo *rel,
^
jdbc_fdw.c: In function ‘jdbcGetForeignPlan’:
jdbc_fdw.c:1079:10: error: too few arguments to function ‘make_foreignscan’
return (make_foreignscan(tlist, scan_clauses, scan_relid, NIL, NIL));
^
In file included from jdbc_fdw.c:45:0:
/usr/include/postgresql/server/optimizer/planmain.h:51:21: note: declared here
extern ForeignScan *make_foreignscan(List *qptlist, List *qpqual,
^
make: *** [jdbc_fdw.o] Error 1
ERROR: command returned 2: make PG_CONFIG=/usr/bin/pg_config all
but this works:
git clone https://github.com/atris/JDBC_FDW
cd ./JDBC_FDW
sudo make USE_PGXS=1
sudo make USE_PGXS=1 install
PostgreSQL version 10beta1.
Is PGXN version 1.0.0 valid?
Hello! I have the following issue:
but this works:
PostgreSQL version 10beta1. Is PGXN version 1.0.0 valid?