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@gardenia.com.ph>
Date: Monday, September 4, 2023 at 13:17
To: Adam Lee <adlee@vmware.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, Ian Lawrence Barwick <barwick@gmail.com>, Christophe Pettus <xof@thebuild.com>, umair.shahid@gmail.com <umair.shahid@gmail.com>, pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: [EXTERNAL] Oracle FDW version
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=#