error installing oracle_fdw extension

From: Sumeet Shukla <sumeet(dot)k(dot)shukla(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: error installing oracle_fdw extension
Date: 2017-05-19 13:50:50
Message-ID: CABUL13566aY6zB_sCSztHCRmaHaVQu8-Wz_VqdktkHegkaC=Mg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'm seeeing below error while installing oracle_fdw

-bash-4.1$ cd
/opt/postgresql/9.6/share/postgresql/extension/oracle_fdw-1.1.0
-bash-4.1$ export PATH=/opt/postgresql/9.6/bin:$PATH
-bash-4.1$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1
-bash-4.1$ export LD_LIBRARY_PATH=/u01/app/oracle/product/
12.1.0.2/db_1/lib:/lib:/usr/lib
-bash-4.1$ make
gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -g -O2 -DMAP_HUGETLB=0x40000
-fpic -I/u01/app/oracle/product/12.1.0.2/db_1/sdk/include
-I/u01/app/oracle/product/12.1.0.2/db_1/oci/include
-I/u01/app/oracle/product/12.1.0.2/db_1/rdbms/public
-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/opt/postgresql/9.6/include/postgresql/server
-I/opt/postgresql/9.6/include/postgresql/internal -D_GNU_SOURCE
-I/opt/local/Current/include/libxml2 -I/opt/local/Current/include -c -o
oracle_fdw.o oracle_fdw.c
oracle_fdw.c: In function ‘oracle_fdw_handler’:
oracle_fdw.c:269: warning: assignment from incompatible pointer type
oracle_fdw.c: In function ‘oracle_diag’:
oracle_fdw.c:441: error: too few arguments to function
‘GetConfigOptionByName’
oracle_fdw.c: In function ‘oracleGetForeignRelSize’:
oracle_fdw.c:751: error: ‘RelOptInfo’ has no member named ‘width’
oracle_fdw.c: In function ‘oracleGetForeignPaths’:
oracle_fdw.c:800: error: incompatible type for argument 3 of
‘create_foreignscan_path’
/opt/postgresql/9.6/include/postgresql/server/optimizer/pathnode.h:90:
note: expected ‘struct PathTarget *’ but argument is of type ‘double’
oracle_fdw.c:800: error: incompatible type for argument 6 of
‘create_foreignscan_path’
/opt/postgresql/9.6/include/postgresql/server/optimizer/pathnode.h:90:
note: expected ‘Cost’ but argument is of type ‘struct List *’
oracle_fdw.c:800: warning: passing argument 8 of ‘create_foreignscan_path’
from incompatible pointer type
/opt/postgresql/9.6/include/postgresql/server/optimizer/pathnode.h:90:
note: expected ‘Relids’ but argument is of type ‘struct List *’
oracle_fdw.c:800: error: too few arguments to function
‘create_foreignscan_path’
oracle_fdw.c: In function ‘oracleGetForeignPlan’:
oracle_fdw.c:839: error: too few arguments to function ‘make_foreignscan’
oracle_fdw.c: In function ‘oraclePlanForeignModify’:
oracle_fdw.c:1226: error: ‘RangeTblEntry’ has no member named ‘modifiedCols’
oracle_fdw.c: In function ‘createQuery’:
oracle_fdw.c:1964: error: ‘RelOptInfo’ has no member named ‘reltargetlist’
oracle_fdw.c: In function ‘getOracleWhereClause’:
oracle_fdw.c:2609: error: too few arguments to function
‘array_create_iterator’
oracle_fdw.c: In function ‘transactionCallback’:
oracle_fdw.c:4262: warning: enumeration value ‘XACT_EVENT_PARALLEL_COMMIT’
not handled in switch
oracle_fdw.c:4262: warning: enumeration value ‘XACT_EVENT_PARALLEL_ABORT’
not handled in switch
oracle_fdw.c:4262: warning: enumeration value
‘XACT_EVENT_PARALLEL_PRE_COMMIT’ not handled in switch
make: *** [oracle_fdw.o] Error 1

Can someone help me with this.

Thanks & Regards,
Sumeet Shukla
Ph. No. 962 323 4700

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-05-19 14:41:31 Re: error installing oracle_fdw extension
Previous Message goutham goud 2017-05-19 04:59:19 Re: Recovey on Master / Primary Server