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 <jethroelmersani...@gardenia.com.ph> Date: Monday, September 4, 2023 at 13:17 To: Adam Lee <ad...@vmware.com> Cc: Adrian Klaver <adrian.kla...@aklaver.com>, Ian Lawrence Barwick <barw...@gmail.com>, Christophe Pettus <x...@thebuild.com>, umair.sha...@gmail.com <umair.sha...@gmail.com>, pgsql-general@lists.postgresql.org <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=#
