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 <[email protected]> Date: Monday, September 4, 2023 at 13:17 To: Adam Lee <[email protected]> Cc: Adrian Klaver <[email protected]>, Ian Lawrence Barwick <[email protected]>, Christophe Pettus <[email protected]>, [email protected] <[email protected]>, [email protected] <[email protected]> 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=#
