Re: [ADMIN] error installing oracle_fdw extension - Mailing list pgsql-admin

From Sumeet Shukla
Subject Re: [ADMIN] error installing oracle_fdw extension
Date
Msg-id CABUL136eQbGZXM2RP3Q4jMxo_FCqTeQDeEWc6PuWibkMJGeQkA@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] error installing oracle_fdw extension  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: [ADMIN] error installing oracle_fdw extension  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
List pgsql-admin
Thanks Tom and Peter. I tried installing the latest version oracle_fdw-1.5.0 and now I see below error:

-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_utils.o oracle_utils.c
oracle_utils.c:22:17: error: oci.h: No such file or directory
oracle_utils.c:35: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘err_code’
oracle_utils.c:48: error: expected specifier-qualifier-list before ‘dvoid’
oracle_utils.c:69: error: expected declaration specifiers or ‘...’ before ‘dvoid’
oracle_utils.c:69: error: expected declaration specifiers or ‘...’ before ‘sb4’
oracle_utils.c:69: error: expected declaration specifiers or ‘...’ before ‘ub2’
oracle_utils.c:69: error: expected declaration specifiers or ‘...’ before ‘ub2’
oracle_utils.c:69: error: expected declaration specifiers or ‘...’ before ‘sb2’
oracle_utils.c:70: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘checkerr’
oracle_utils.c:72: error: expected ‘)’ before ‘*’ token 


Thanks & Regards,
Sumeet Shukla


On Sat, May 20, 2017 at 12:23 AM, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
On 5/19/17 10:41, Tom Lane wrote:
> Sumeet Shukla <sumeet.k.shukla@gmail.com> writes:
>> I'm seeeing below error while installing oracle_fdw
>
> Looks like the version of oracle_fdw you're trying to install has
> not been updated for PG 9.6.  You need to ask its developers
> whether there's a newer version.

Yes, there are newer versions that support 9.6 and 10.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [ADMIN] Re: Not able to find an alternative for SELECT TOP n WITHTIES in postgresql which is available in sql server.
Next
From: Julien Rouhaud
Date:
Subject: Re: [ADMIN] error installing oracle_fdw extension