undefined symbol about oracle_fdw HOT 9 CLOSED

The version is 2.6.0

from oracle_fdw.

Strange.
Perhaps you could start by telling me

• the operating system you are using
• the PostgreSQL version you are using
• how you did install PostgreSQL
• how you built and installed oracle_fdw

from oracle_fdw.

the operating system is Rocky9.4 the PostgreSQL version is 12.12 I use postgresql from greenplum7.2-beta I used both oracle_fdw-ORACLE_FDW_2_6_0.tar.gz and oracle_fdw-ORACLE_FDW_2_3_0.tar.gz to have this problem and used oracle-instantclient19.19 development packages

from oracle_fdw.

I guess "Greenplum" is the problem here.

Can you check if it works with regular PostgreSQL on your system?

from oracle_fdw.

we need use greenplum so we not have regular PostgreSQL in any system the greenplum uesd postgresql12.12 I try install the s postgresql12-devel package in /usr/pgsql-12 and edit the MakeFile to make (Added parameter PG_CPPFLAGS -I/usr/pgsql-12/include/server -I/usr/include/oracle/19.19/client64)

from oracle_fdw.

from oracle_fdw.

I don't understand your last two comments.

Anyway, if you need to use Greenplum, I guess you cannot use oracle_fdw.
oracle_fdw is an extension for PostgreSQL.

from oracle_fdw.

I did it

from oracle_fdw.

So you mean you got oracle_fdw to build with Greenplum?
If yes, that would be interesting to know.
What did you have to do to make it work?

from oracle_fdw.