Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYeiX-002K5A-Es for pgsql-general@arkaria.postgresql.org; Wed, 23 Aug 2023 03:39:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qYeiU-008cPz-UR for pgsql-general@arkaria.postgresql.org; Wed, 23 Aug 2023 03:39:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYeiU-008cPh-IY for pgsql-general@lists.postgresql.org; Wed, 23 Aug 2023 03:39:34 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYeiQ-000S2u-Vj for pgsql-general@lists.postgresql.org; Wed, 23 Aug 2023 03:39:32 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 37N3dJDQ3259596; Tue, 22 Aug 2023 23:39:19 -0400 From: Tom Lane To: Jethro Elmer Sanidad cc: Adrian Klaver , umair.shahid@gmail.com, pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL] Re: Oracle FDW version In-reply-to: References: <0471ed6b-a43a-350f-f525-68c91fcd8719@aklaver.com> Comments: In-reply-to Jethro Elmer Sanidad message dated "Wed, 23 Aug 2023 10:57:03 +0800" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <3259594.1692761959.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 22 Aug 2023 23:39:19 -0400 Message-ID: <3259595.1692761959@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Jethro Elmer Sanidad writes: > I tried both the 1.5.0 and 2.0.0. Both returned error during 'make' > command. Please see below: So evidently, > oracle_fdw.c: In function =E2=80=98oracleGetForeignRelSize=E2=80=99: > oracle_fdw.c:884:3: error: too few arguments to function =E2=80=98clause= list_selectivity=E2=80=99 > ntuples =3D ntuples * clauselist_selectivity(root, baserel->baserestr= ictinfo, 0, JOIN_INNER, NULL); > In file included from oracle_fdw.c:48:0: > /usr/local/greenplum-db-6.7.1/include/postgresql/server/optimizer/cost.h= :225:20: > note: declared here your compatibility problem is not with Postgres 9.4.x at all, but with some version of Greenplum. (Aside from the giveaway include path, no extant version of community Postgres has a cost.h file that is as much as 225 lines long, nor do we expect clauselist_selectivity to take more than five arguments.) Please speak to Greenplum customer support, rather than expecting the wider Postgres community to help you for free with a code base that we don't even know. regards, tom lane