Re: [EXTERNAL] Re: Oracle FDW version

Поиск
Список
Период
Сортировка
От Jethro Elmer Sanidad
Тема Re: [EXTERNAL] Re: Oracle FDW version
Дата
Msg-id CAOvgYW39t6RFWZ2Oix74D5EgceABBuvKVmqX24T3f-KH-TZj4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Oracle FDW version  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [EXTERNAL] Re: Oracle FDW version
Re: [EXTERNAL] Oracle FDW version
Список pgsql-general
Дерево обсуждения
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_FDW_2_0_0]$ make
gcc -m64 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fno-aggressive-loop-optimizations -Wno-unused-but-set-variable -Wno-address -m64 -O3 -fargument-noalias-global -fno-omit-frame-pointer -g -std=gnu99   -Werror=uninitialized -Werror=implicit-function-declaration -fPIC -I/sdk/include -I/oci/include -I/rdbms/public -I/usr/include/oracle/12.2/client -I/usr/include/oracle/12.2/client64 -I/usr/include/oracle/12.1/client -I/usr/include/oracle/12.1/client64 -I/usr/include/oracle/11.2/client -I/usr/include/oracle/11.2/client64 -I/usr/include/oracle/11.1/client -I/usr/include/oracle/11.1/client64 -I/usr/include/oracle/10.2.0.5/client -I/usr/include/oracle/10.2.0.5/client64 -I/usr/include/oracle/10.2.0.4/client -I/usr/include/oracle/10.2.0.4/client64 -I/usr/include/oracle/10.2.0.3/client -I/usr/include/oracle/10.2.0.3/client64 -I. -I./ -I/usr/local/greenplum-db-6.7.1/include/postgresql/server -I/usr/local/greenplum-db-6.7.1/include/postgresql/internal -D_GNU_SOURCE -I/usr/include/libxml2  -I/tmp/build/f8c7ee08/gpdb_src/gpAux/ext/rhel7_x86_64/include  -c -o oracle_fdw.o oracle_fdw.c
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
 extern Selectivity clauselist_selectivity(PlannerInfo *root,
                    ^
oracle_fdw.c: In function ‘oracleIterateForeignScan’:
oracle_fdw.c:1445:31: error: ‘TupleTableSlot’ has no member named ‘tts_values’
   convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                               ^
oracle_fdw.c:1445:49: error: ‘TupleTableSlot’ has no member named ‘tts_isnull’
   convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                                                 ^
oracle_fdw.c: In function ‘oracleExecForeignInsert’:
oracle_fdw.c:2044:30: error: ‘TupleTableSlot’ has no member named ‘tts_values’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                              ^
oracle_fdw.c:2044:48: error: ‘TupleTableSlot’ has no member named ‘tts_isnull’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                                                ^
oracle_fdw.c: In function ‘oracleExecForeignUpdate’:
oracle_fdw.c:2090:30: error: ‘TupleTableSlot’ has no member named ‘tts_values’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                              ^
oracle_fdw.c:2090:48: error: ‘TupleTableSlot’ has no member named ‘tts_isnull’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                                                ^
oracle_fdw.c: In function ‘oracleExecForeignDelete’:
oracle_fdw.c:2136:30: error: ‘TupleTableSlot’ has no member named ‘tts_values’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                              ^
oracle_fdw.c:2136:48: error: ‘TupleTableSlot’ has no member named ‘tts_isnull’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                                                ^
make: *** [oracle_fdw.o] Error 1

-----------------------------------------------------------------------------------------------------------------------------------------------------------

[gpadmin@gbpi-fmstr-uat-danalytics-01 oracle_fdw-ORACLE_FDW_1_5_0]$ make
gcc -m64 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fno-aggressive-loop-optimizations -Wno-unused-but-set-variable -Wno-address -m64 -O3 -fargument-noalias-global -fno-omit-frame-pointer -g -std=gnu99   -Werror=uninitialized -Werror=implicit-function-declaration -fPIC -I/sdk/include -I/oci/include -I/rdbms/public -I/usr/include/oracle/12.1/client -I/usr/include/oracle/12.1/client64 -I/usr/include/oracle/11.2/client -I/usr/include/oracle/11.2/client64 -I/usr/include/oracle/11.1/client -I/usr/include/oracle/11.1/client64 -I/usr/include/oracle/10.2.0.5/client -I/usr/include/oracle/10.2.0.5/client64 -I/usr/include/oracle/10.2.0.4/client -I/usr/include/oracle/10.2.0.4/client64 -I/usr/include/oracle/10.2.0.3/client -I/usr/include/oracle/10.2.0.3/client64 -I. -I./ -I/usr/local/greenplum-db-6.7.1/include/postgresql/server -I/usr/local/greenplum-db-6.7.1/include/postgresql/internal -D_GNU_SOURCE -I/usr/include/libxml2  -I/tmp/build/f8c7ee08/gpdb_src/gpAux/ext/rhel7_x86_64/include  -c -o oracle_fdw.o oracle_fdw.c
oracle_fdw.c: In function ‘oracleGetForeignRelSize’:
oracle_fdw.c:880:3: error: too few arguments to function ‘clauselist_selectivity’
   ntuples = ntuples * clauselist_selectivity(root, local_conditions, 0, JOIN_INNER, NULL);
   ^
In file included from oracle_fdw.c:41:0:
/usr/local/greenplum-db-6.7.1/include/postgresql/server/optimizer/cost.h:225:20: note: declared here
 extern Selectivity clauselist_selectivity(PlannerInfo *root,
                    ^
oracle_fdw.c: In function ‘oracleIterateForeignScan’:
oracle_fdw.c:1157:31: error: ‘TupleTableSlot’ has no member named ‘tts_values’
   convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                               ^
oracle_fdw.c:1157:49: error: ‘TupleTableSlot’ has no member named ‘tts_isnull’
   convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                                                 ^
oracle_fdw.c: In function ‘oracleExecForeignInsert’:
oracle_fdw.c:1758:30: error: ‘TupleTableSlot’ has no member named ‘tts_values’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                              ^
oracle_fdw.c:1758:48: error: ‘TupleTableSlot’ has no member named ‘tts_isnull’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                                                ^
oracle_fdw.c: In function ‘oracleExecForeignUpdate’:
oracle_fdw.c:1804:30: error: ‘TupleTableSlot’ has no member named ‘tts_values’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                              ^
oracle_fdw.c:1804:48: error: ‘TupleTableSlot’ has no member named ‘tts_isnull’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                                                ^
oracle_fdw.c: In function ‘oracleExecForeignDelete’:
oracle_fdw.c:1850:30: error: ‘TupleTableSlot’ has no member named ‘tts_values’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                              ^
oracle_fdw.c:1850:48: error: ‘TupleTableSlot’ has no member named ‘tts_isnull’
  convertTuple(fdw_state, slot->tts_values, slot->tts_isnull, false);
                                                ^
make: *** [oracle_fdw.o] Error 1

On Wed, Aug 23, 2023 at 10:50 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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



--

image.png

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.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Oracle FDW version
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: [EXTERNAL] Oracle FDW version