Re: [EXTERNAL] Re: Oracle FDW version

2023-08-22 Thread Tom Lane
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 ‘oracleGetForeignRelSize’: > oracle_fdw.c:884:3: error: too few arguments to function > ‘clauselist_selectivity’ >ntuples

Re: [EXTERNAL] Re: Oracle FDW version

2023-08-22 Thread Jethro Elmer Sanidad
Hello, I tried both the 1.5.0 and 2.0.0. Both returned error during 'make' command. Please see below: [gpadmin@gbpi-fmstr-uat-danalytics-01 oracle_fdw-ORACLE_F

Re: Oracle FDW version

2023-08-22 Thread Adrian Klaver
On 8/22/23 19:25, Jethro Elmer Sanidad wrote: Hello, Can you provide us download links for oracle_fdw for psql (PostgreSQL) 9.4.24. Currently, we can't find oracle_fdw that will be compatible to the said PostgreSQL version. Per chatGPT, the oracle_fdw version should be 1.8.1 for the said Post

Re: Oracle FDW version

2023-08-22 Thread Tom Lane
Jethro Elmer Sanidad writes: > Can you provide us download links for oracle_fdw for psql (PostgreSQL) > 9.4.24. PG 9.4.x has been out of support since 2020 [1]. You need to be looking to upgrade that server to something that's in support, and then you can probably find a matching in-support orac