Re: [EXTERNAL] Oracle FDW version

[Adam Lee]

The original poster was building against Greenplum 6, it’s expected to fail.

Try this https://github.com/adam8157/oracle_fdw_greenplum, it’s not based on 
the lasts oracle_fdw, but likely easy to rebase.

From: Adrian Klaver 
Date: Thursday, August 24, 2023 at 15:19
To: Jethro Elmer Sanidad , Ian Lawrence 
Barwick 
Cc: Christophe Pettus , umair.sha...@gmail.com 
, pgsql-general@lists.postgresql.org 

Subject: Re: [EXTERNAL] Oracle FDW version
!! External Email

On 8/22/23 23:10, Jethro Elmer Sanidad wrote:
> Hello,
>
> Can you confirm in this email that our current version of PostgreSQL
> (9.2.24) is not compatible with any of oracle_fdw versions released? And
> you are recommending an upgrade? Thanks!

In your first post you said:

"Can you provide us download links for oracle_fdw for psql (PostgreSQL)
9.4.24. ..."

1) Are you on 9.2 or 9.4?

2) Where did you get Postgres from?


--
Adrian Klaver
adrian.kla...@aklaver.com






!! External Email: This email originated from outside of the organization. Do 
not click links or open attachments unless you recognize the sender.

Re: [EXTERNAL] Oracle FDW version

[Adam Lee]

That warning is misleading while creating extensions. Check the runtime linking 
of oracle_fdw.so,
probably some dependencies are missing. Greenplum failed to detect such issues 
and errored out
at a wrong place.

Since it’s an issue only happens on Greenplum, please continue the discussion 
off the mailing list.

From: Jethro Elmer Sanidad 
Date: Monday, September 4, 2023 at 13:17
To: Adam Lee 
Cc: Adrian Klaver , Ian Lawrence Barwick 
, Christophe Pettus , 
umair.sha...@gmail.com , 
pgsql-general@lists.postgresql.org 
Subject: Re: [EXTERNAL] Oracle FDW version
!! External Email
Hello,

I already installed your extension. As of now, I'm having issues in creating 
the oracle_fdw. Please advise. Thanks!

postgres=# create extension oracle_fdw;
ERROR:  query plan with multiple segworker groups is not supported
HINT:  likely caused by a function that reads or modifies data in a distributed 
table
postgres=#