Re: [EXTERNAL] Oracle FDW version

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 <jethroelmersanidad(at)gardenia(dot)com(dot)ph>
Date: Monday, September 4, 2023 at 13:17
To: Adam Lee <adlee(at)vmware(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Ian Lawrence Barwick <barwick(at)gmail(dot)com>, Christophe Pettus <xof(at)thebuild(dot)com>, umair(dot)shahid(at)gmail(dot)com <umair(dot)shahid(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)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=#