PG 下面Orache_fdw 安装报错

Oracle fdw ‘RelOptInfo’ has no member named ‘lateral_relids’ Error

I am trying to set up the latest version Oracle_fdw extension on Postgresql. My Postgresql is working on Centos. I get an error like;

"oracle_fdw.c: In function ‘oracleGetForeignPaths’: oracle_fdw.c:1003:13: error: ‘RelOptInfo’ has no member named ‘lateral_relids’ baserel->lateral_relids,"

When i try to "make" command on oracle_fdw folder get an error like this:

gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DLINUX_OOM_SCORE_ADJ=0 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fPIC -I/usr/lib/oracle/19.3/client64/lib/sdk/include -I/usr/lib/oracle/19.3/client64/lib/oci/include -I/usr/lib/oracle/19.3/client64/lib/rdbms/public -I/usr/include/oracle/19.3/client -I/usr/include/oracle/19.3/client64 -I/usr/include/oracle/18.5/client -I/usr/include/oracle/18.5/client64 -I/usr/include/oracle/18.3/client -I/usr/include/oracle/18.3/client64 -I/usr/include/oracle/12.2/client -I/usr/include/oracle/12.2/client64 -I/usr/include/oracle/12.1/client -I/usr/include/oracle/12.1/client64 -I/usr/include/oracle/11.2/client -I/usr/include/oracle/11.2/client64 -I/usr/include/oracle/11.1/client -I/usr/include/oracle/11.1/client64 -I/usr/include/oracle/10.2.0.5/client -I/usr/include/oracle/10.2.0.5/client64 -I/usr/include/oracle/10.2.0.4/client -I/usr/include/oracle/10.2.0.4/client64 -I/usr/include/oracle/10.2.0.3/client -I/usr/include/oracle/10.2.0.3/client64 -I. -I. -I/usr/include/pgsql/server -I/usr/include/pgsql/internal -D_GNU_SOURCE -I/usr/include/libxml2 -c -o oracle_fdw.o oracle_fdw.c oracle_fdw.c: In function ‘oracleGetForeignPaths’: oracle_fdw.c:1003:13: error: ‘RelOptInfo’ has no member named ‘lateral_relids’ baserel->lateral_relids, ^ oracle_fdw.c: At top level: oracle_fdw.c:385:13: warning: ‘hasTrigger’ used but never defined [enabled by default] static bool hasTrigger(Relation rel, CmdType cmdtype); ^ oracle_fdw.c:386:13: warning: ‘buildInsertQuery’ declared ‘static’ but never defined [-Wunused-function] static void buildInsertQuery(StringInfo sql, struct OracleFdwState fdwState); ^ oracle_fdw.c:387:13: warning: ‘buildUpdateQuery’ declared ‘static’ but never defined [-Wunused-function] static void buildUpdateQuery(StringInfo sql, struct OracleFdwState fdwState, List targetAttrs); ^ oracle_fdw.c:388:13: warning: ‘appendReturningClause’ declared ‘static’ but never defined [-Wunused-function] static void appendReturningClause(StringInfo sql, struct OracleFdwState fdwState);

Can you help me about that?

Thanks

------------------------------ Answer:

RelOptInfo has had member lateral_relids ever since commit 9ff79b9d4e71822a875c0f5e38f5ec86c7fb079f, so it has been present in every PostgreSQL release since 9.3, when LATERAL was introduced.

You must be building against a really old version of PostgreSQL,like 9.2 Check pg_config --version for the exact version.

You should change to higher build against like v10 explicitly:

PATH=/usr/pgsql-10/bin:$PATH make clean
PATH=/usr/pgsql-10/bin:$PATH make