Thread: Oracle FDW version

CONFIDENTIALITY NOTICE: This email is confidential and subject to legal rights of Gardenia Bakeries (Philippines), Inc. (“GBPI”). If you received this email by error, you must not use or disclose any information in it and immediately notify the sender by return email and permanently delete this email (and all attachments) without any use of its contents. To the extent legally permitted, GBPI has no liability of any kind arising out of or in connection with any virus transmitted by this email, attachments, and/or any errors or omissions in content including transmissions through unauthorised use or tampering of email system and/or the integrity of the email being compromised. Any personal statements or opinions in this communication are those of the individual sender and do not reflect the views of GBPI. GBPI will never consent to or authorize the publication of defamatory statements or infringement of intellectual property. Only individuals authorized by GBPI’s Board of Directors may sign and/or accept proposals, contracts, or agreements as well as waive any legal right of GBPI. Any personal information in this email must be handled in accordance with the Data Privacy Act of 2012 of the Philippines and its implementing rules and regulations.

Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph> 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 oracle_fdw version.

            regards, tom lane

[1] https://www.postgresql.org/support/versioning/

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 PostgreSQL version.  We already checked in 

 From what I see ChatGPT is making things up again.

If you go here:

https://github.com/laurenz/oracle_fdw

the tags go from:

https://github.com/laurenz/oracle_fdw/tree/ORACLE_FDW_1_5_0

to

https://github.com/laurenz/oracle_fdw/tree/ORACLE_FDW_2_0_0

Personally I would try the 2.0 version. That came out(2017-09-15) in the 
middle of 9.4's life span(9.4     9.4.26     No     December 18, 2014     February 
13, 2020).


> laurenz's github but there is no oracle_fdw version 1.8.1 in his 
> repository. Thanks!
> 
> -- 
> 
> image.png <http://www.gardenia.com.ph/>
> 
> *Jethro Elmer T. Sanidad*
> Management Information Systems
> O: +63 2 8889 8890 loc. 1354 | M: +63 9686809253
> Gardenia Bakeries Philippines Incorporated | Laguna International 
> Industrial Park (LIIP) | Binan 4024 | Laguna
> 
> 
> *CONFIDENTIALITY NOTICE:* This email is confidential and subject to 
> legal rights of Gardenia Bakeries (Philippines), Inc. (“GBPI”). If you 
> received this email by error, you must not use or disclose any 
> information in it and immediately notify the sender by return email and 
> permanently delete this email (and all attachments) without any use of 
> its contents. To the extent legally permitted, GBPI has no liability of 
> any kind arising out of or in connection with any virus transmitted by 
> this email, attachments, and/or any errors or omissions in content 
> including transmissions through unauthorised use or tampering of email 
> system and/or theintegrity of the email being compromised. Any personal 
> statements or opinions in this communication are those of the individual 
> sender and do not reflect the views of GBPI. GBPI will never consent to 
> or authorize the publication of defamatory statements or infringement of 
> intellectual property. Only individuals authorized by GBPI’s Board of 
> Directors may sign and/or accept proposals, contracts, or agreements as 
> well as waive any legal right of GBPI. Any personal information in this 
> email must be handled in accordance with the Data Privacy Act of 2012 of 
> the Philippines and its implementing rules and regulations.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

CONFIDENTIALITY NOTICE: This email is confidential and subject to legal rights of Gardenia Bakeries (Philippines), Inc. (“GBPI”). If you received this email by error, you must not use or disclose any information in it and immediately notify the sender by return email and permanently delete this email (and all attachments) without any use of its contents. To the extent legally permitted, GBPI has no liability of any kind arising out of or in connection with any virus transmitted by this email, attachments, and/or any errors or omissions in content including transmissions through unauthorised use or tampering of email system and/or the integrity of the email being compromised. Any personal statements or opinions in this communication are those of the individual sender and do not reflect the views of GBPI. GBPI will never consent to or authorize the publication of defamatory statements or infringement of intellectual property. Only individuals authorized by GBPI’s Board of Directors may sign and/or accept proposals, contracts, or agreements as well as waive any legal right of GBPI. Any personal information in this email must be handled in accordance with the Data Privacy Act of 2012 of the Philippines and its implementing rules and regulations.

> On Aug 22, 2023, at 19:57, Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph> 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
toupgrade your server to something in-support. 

Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.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

2023年8月23日(水) 12:47 Christophe Pettus <xof@thebuild.com>:
>
>
>
> > On Aug 22, 2023, at 19:57, Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph> 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
toupgrade your server to something in-support. 

FWIW oracle_fdw should actually build against PostgreSQL as far back as 9.3
(though finding packages would be a fruitless endeavour); the documentation
does explicitly mention that it will likely not build against forks which are
not compatible with the community code [1].

[1] https://github.com/laurenz/oracle_fdw#5-installation-requirements

Regards

Ian Barwick

CONFIDENTIALITY NOTICE: This email is confidential and subject to legal rights of Gardenia Bakeries (Philippines), Inc. (“GBPI”). If you received this email by error, you must not use or disclose any information in it and immediately notify the sender by return email and permanently delete this email (and all attachments) without any use of its contents. To the extent legally permitted, GBPI has no liability of any kind arising out of or in connection with any virus transmitted by this email, attachments, and/or any errors or omissions in content including transmissions through unauthorised use or tampering of email system and/or the integrity of the email being compromised. Any personal statements or opinions in this communication are those of the individual sender and do not reflect the views of GBPI. GBPI will never consent to or authorize the publication of defamatory statements or infringement of intellectual property. Only individuals authorized by GBPI’s Board of Directors may sign and/or accept proposals, contracts, or agreements as well as waive any legal right of GBPI. Any personal information in this email must be handled in accordance with the Data Privacy Act of 2012 of the Philippines and its implementing rules and regulations.

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 PostgreSQL, but are instead
using a special proprietary spin-off called Greenplum.

If that's the case, then you'll need to have a chat with the Greenplum
support people.  They'll know their product better than we do. :)

Regards and best wishes,

Justin Clift

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 download links for oracle_fdw for psql (PostgreSQL) 
9.4.24. ..."

1) Are you on 9.2 or 9.4?

2) Where did you get Postgres from?


-- 
Adrian Klaver
adrian.klaver@aklaver.com

CONFIDENTIALITY NOTICE: This email is confidential and subject to legal rights of Gardenia Bakeries (Philippines), Inc. (“GBPI”). If you received this email by error, you must not use or disclose any information in it and immediately notify the sender by return email and permanently delete this email (and all attachments) without any use of its contents. To the extent legally permitted, GBPI has no liability of any kind arising out of or in connection with any virus transmitted by this email, attachments, and/or any errors or omissions in content including transmissions through unauthorised use or tampering of email system and/or the integrity of the email being compromised. Any personal statements or opinions in this communication are those of the individual sender and do not reflect the views of GBPI. GBPI will never consent to or authorize the publication of defamatory statements or infringement of intellectual property. Only individuals authorized by GBPI’s Board of Directors may sign and/or accept proposals, contracts, or agreements as well as waive any legal right of GBPI. Any personal information in this email must be handled in accordance with the Data Privacy Act of 2012 of the Philippines and its implementing rules and regulations.

CONFIDENTIALITY NOTICE: This email is confidential and subject to legal rights of Gardenia Bakeries (Philippines), Inc. (“GBPI”). If you received this email by error, you must not use or disclose any information in it and immediately notify the sender by return email and permanently delete this email (and all attachments) without any use of its contents. To the extent legally permitted, GBPI has no liability of any kind arising out of or in connection with any virus transmitted by this email, attachments, and/or any errors or omissions in content including transmissions through unauthorised use or tampering of email system and/or the integrity of the email being compromised. Any personal statements or opinions in this communication are those of the individual sender and do not reflect the views of GBPI. GBPI will never consent to or authorize the publication of defamatory statements or infringement of intellectual property. Only individuals authorized by GBPI’s Board of Directors may sign and/or accept proposals, contracts, or agreements as well as waive any legal right of GBPI. Any personal information in this email must be handled in accordance with the Data Privacy Act of 2012 of the Philippines and its implementing rules and regulations.