2023年8月23日(水) 15:10 Jethro Elmer Sanidad <jethroelmersani...@gardenia.com.ph >:
> 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 *community* PostgreSQL 9.3 and later (I just verfied that) - it is likely not compatible with PostgreSQL forks such as Greenplum - if you are running a version of PostgreSQL based on 9.2.x or 9.4.x it's hopelessly out-of-date and you should definitely upgrade anyway (but if it's a fork, that still won't that mean oracle_fdw will compile against it) HTH Ian Barwick > > On Wed, Aug 23, 2023 at 2:04 PM Ian Lawrence Barwick <barw...@gmail.com> > wrote: > >> 2023年8月23日(水) 12:47 Christophe Pettus <x...@thebuild.com>: >> > >> > >> > >> > > On Aug 22, 2023, at 19:57, Jethro Elmer Sanidad < >> jethroelmersani...@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 to upgrade 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 >> > > > -- > > [image: 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 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. >