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

Re: JDBC + PG-15 but not psql

2023-08-22 Thread Amn Ojee Uw
Yes your are right! I don't know why it was part of the requirement to add a JDBC line to explicitly set the behaviour of autocommint to *true*, when it was the default value. Perhaps it has to do with "just making sure it is" sort of thing. Thanks Dave, I'll let the my group know. On 8/22/23

Released vasco: a PG extension to compute MIC and MINE correlation statistics

2023-08-22 Thread Florents Tselai
Hello, If you're looking for a more powerful alternative to corr(X, Y), I just open - sourced an vasco [0] vasco is a Postgres extension that helps you discover hidden correlations in your data. It is based on the MIC and MINE family of statistics. [0] https://github.com/Florents-Tselai/vasco

Re: JDBC + PG-15 but not psql

2023-08-22 Thread Dave Cramer
Hi Amn, What I don't understand is the requirement to set autocommit to true since this is the default ? Either way this is expected behaviour as psql also has autocommit true by default. Thanks, Dave Cramer On Mon, 21 Aug 2023 at 20:57, Amn Ojee Uw wrote: > Thanks Dave for your interest.

Re: The same prepared query yield "-1" the first six times and then "-1.0"

2023-08-22 Thread Dave Cramer
On Tue, 22 Aug 2023 at 01:54, Edoardo Panfili wrote: > > > Il giorno 21 ago 2023, alle ore 21:37, Dave Cramer > ha scritto: > > > > On Mon, 21 Aug 2023 at 14:42, Edoardo Panfili wrote: > >> >> >> > Il giorno 21 ago 2023, alle ore 20:13, Peter J. Holzer < >> hjp-pg...@hjp.at> ha scritto: >> > >>