Re: BUG #15648: oracle_fdw extension not able to create

Hi Andrew,

I have config path for /usr/pgsql-11/bin/pg_config and CC mean?

[root(at)brurhenppp001 oracle_fdw-2.1.0]# ll
total 1796
-rw-r--r--. 1 postgres postgres 15887 Sep 25 12:04 CHANGELOG
drwxr-xr-x. 2 postgres postgres 123 Sep 25 12:04 expected
-rw-r--r--. 1 postgres postgres 1086 Sep 25 12:04 LICENSE
-rw-r--r--. 1 postgres postgres 1968 Sep 25 12:04 Makefile
-rw-r--r--. 1 postgres postgres 1459 Sep 25 12:17 META.json
drwxr-xr-x. 2 postgres postgres 99 Sep 25 12:04 msvc
-rw-r--r--. 1 postgres postgres 231 Sep 25 12:04 oracle_fdw--1.0--1.1.sql
-rw-r--r--. 1 postgres postgres 1003 Sep 25 12:04 oracle_fdw--1.1.sql
-rw-r--r--. 1 postgres postgres 194018 Sep 25 12:04 oracle_fdw.c
-rw-r--r--. 1 postgres postgres 133 Sep 25 12:04 oracle_fdw.control
-rw-r--r--. 1 postgres postgres 8284 Sep 25 12:04 oracle_fdw.h
-rw-------. 1 postgres postgres 570584 Feb 15 16:46 oracle_fdw.o
-rwx------. 1 postgres postgres 528736 Feb 22 09:42 oracle_fdw.so
-rw-r--r--. 1 postgres postgres 44474 Sep 25 12:04 oracle_gis.c
-rw-------. 1 postgres postgres 122328 Feb 22 09:42 oracle_gis.o
-rw-r--r--. 1 postgres postgres 93976 Sep 25 12:04 oracle_utils.c
-rw-------. 1 postgres postgres 173136 Feb 22 09:42 oracle_utils.o
-rw-r--r--. 1 postgres postgres 37530 Sep 25 12:04 README.oracle_fdw
drwxr-xr-x. 2 postgres postgres 98 Sep 25 12:04 sql
-rw-r--r--. 1 postgres postgres 315 Sep 25 12:04 TODO
[root(at)brurhenppp001 oracle_fdw-2.1.0]# export
ORACLE_HOME=/opt/app/oracle/product/12.1.0/client_64/

Please share me the full command how to run the make file?

On Mon, Feb 25, 2019 at 7:27 AM Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
wrote:

> >>>>> "Euler" == Euler Taveira <euler(at)timbira(dot)com(dot)br> writes:
>
> >> make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found
> >> make: *** [oracle_fdw.bc] Error 127
>
> Euler> There is something wrong with your env. Do you have CC set? What
> Euler> is your pg_config output?
>
> This is what you get if you try and compile extensions against a server
> built with --with-llvm, on a machine that doesn't have clang installed.
> I mentioned to Andres that we really ought to have an official way to
> disable the LLVM bitcode build for such cases, but right now there isn't
> one. "with_llvm=no" on the make command line is worth a try, but I
> wouldn't bet much on it working.
>
> Otherwise, install llvm version 7 (including clang).
>
> --
> Andrew (irc:RhodiumToad)
>

--

Regards,
Prakash.R
Postgresql DBA