Re: [EXTERNAL] Re: Oracle FDW version

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jethro Elmer Sanidad <jethroelmersanidad(at)gardenia(dot)com(dot)ph>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, umair(dot)shahid(at)gmail(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: [EXTERNAL] Re: Oracle FDW version
Date: 2023-08-23 03:39:19
Message-ID: 3259595.1692761959@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jethro Elmer Sanidad <jethroelmersanidad(at)gardenia(dot)com(dot)ph> 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 ‘oracleGetForeignRelSize’:
> oracle_fdw.c:884:3: error: too few arguments to function ‘clauselist_selectivity’
> ntuples = ntuples * clauselist_selectivity(root, baserel->baserestrictinfo, 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2023-08-23 06:04:15 Re: [EXTERNAL] Oracle FDW version
Previous Message Christophe Pettus 2023-08-23 03:31:07 Re: [EXTERNAL] Oracle FDW version