Re: [EXTERNAL] Oracle FDW version

2023-09-04 Thread Adam Lee
the mailing list. From: Jethro Elmer Sanidad Date: Monday, September 4, 2023 at 13:17 To: Adam Lee Cc: Adrian Klaver , Ian Lawrence Barwick , Christophe Pettus , umair.sha...@gmail.com , pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL] Oracle FDW version !! External Email Hello, I

Re: [EXTERNAL] Oracle FDW version

2023-09-03 Thread Jethro Elmer Sanidad
om: *Adrian Klaver >> *Date: *Thursday, August 24, 2023 at 15:19 >> *To: *Jethro Elmer Sanidad , Ian >> Lawrence Barwick >> *Cc: *Christophe Pettus , umair.sha...@gmail.com < >> umair.sha...@gmail.com>, pgsql-general@lists.postgresql.org < >> pgsq

Re: [EXTERNAL] Oracle FDW version

2023-08-31 Thread Jethro Elmer Sanidad
org < > pgsql-general@lists.postgresql.org> > *Subject: *Re: [EXTERNAL] Oracle FDW version > > !! External Email > > On 8/22/23 23:10, Jethro Elmer Sanidad wrote: > > Hello, > > > > Can you confirm in this email that our current version of PostgreSQL >

Re: [EXTERNAL] Oracle FDW version

2023-08-24 Thread Adam Lee
Lawrence Barwick Cc: Christophe Pettus , umair.sha...@gmail.com , pgsql-general@lists.postgresql.org Subject: Re: [EXTERNAL] Oracle FDW version !! External Email On 8/22/23 23:10, Jethro Elmer Sanidad wrote: > Hello, > > Can you confirm in this email that our current version of P

Re: [EXTERNAL] Oracle FDW version

2023-08-23 Thread Adrian Klaver
On 8/22/23 23:10, Jethro Elmer Sanidad wrote: Hello, Can you confirm in this email that our current version of PostgreSQL (9.2.24) is not compatible with any of oracle_fdw versions released? And you are recommending an upgrade? Thanks! In your first post you said: "Can you provide us downlo

Re: [EXTERNAL] Oracle FDW version

2023-08-23 Thread Ian Lawrence Barwick
2023年8月23日(水) 15:10 Jethro Elmer Sanidad : > Hello, > > Can you confirm in this email that our current version of PostgreSQL > (9.2.24) is not compatible with any of oracle_fdw versions released? And > you are recommending an upgrade? Thanks! > OK, here's the summary: - oracle_fdw builds against

Re: [EXTERNAL] Oracle FDW version

2023-08-22 Thread Justin Clift
On 2023-08-23 16:10, Jethro Elmer Sanidad wrote: Hello, Can you confirm in this email that our current version of PostgreSQL (9.2.24) is not compatible with any of oracle_fdw versions released? And you are recommending an upgrade? Thanks! It seems more like you're not actually using PostgreS

Re: [EXTERNAL] Oracle FDW version

2023-08-22 Thread Jethro Elmer Sanidad
Hello, Can you confirm in this email that our current version of PostgreSQL (9.2.24) is not compatible with any of oracle_fdw versions released? And you are recommending an upgrade? Thanks! On Wed, Aug 23, 2023 at 2:04 PM Ian Lawrence Barwick wrote: > 2023年8月23日(水) 12:47 Christophe Pettus : > >

Re: [EXTERNAL] Oracle FDW version

2023-08-22 Thread Ian Lawrence Barwick
2023年8月23日(水) 12:47 Christophe Pettus : > > > > > On Aug 22, 2023, at 19:57, Jethro Elmer Sanidad > > wrote: > > > > Hello, > > > > I tried both the 1.5.0 and 2.0.0. Both returned error during 'make' > > command. Please see below: > > The API between PostgreSQL and foreign data wrappers has chan

Re: [EXTERNAL] Oracle FDW version

2023-08-22 Thread Christophe Pettus
> On Aug 22, 2023, at 19:57, Jethro Elmer Sanidad > wrote: > > Hello, > > I tried both the 1.5.0 and 2.0.0. Both returned error during 'make' command. > Please see below: The API between PostgreSQL and foreign data wrappers has changed significantly since 9.4. As Tom mentioned, you need

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

Oracle FDW version

2023-08-22 Thread Jethro Elmer Sanidad
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 PostgreSQL version. We already checked in laurenz's gi