pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle FDW version
15+ messages / 7 participants
[nested] [flat]
* Oracle FDW version
@ 2023-08-23 02:25 Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:38 ` Re: Oracle FDW version Tom Lane <tgl@sss.pgh.pa.us>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 2 replies; 15+ messages in thread
From: Jethro Elmer Sanidad @ 2023-08-23 02:25 UTC (permalink / raw)
To: umair.shahid@gmail.com; +Cc: pgsql-general@lists.postgresql.org
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
github but there is no oracle_fdw version 1.8.1 in his repository. Thanks!
--
[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.
Attachments:
image.png (image/png, 73.8K) download
view image
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-08-23 02:38 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 15+ messages in thread
From: Tom Lane @ 2023-08-23 02:38 UTC (permalink / raw)
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; +Cc: umair.shahid@gmail.com; pgsql-general@lists.postgresql.org
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/
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-08-23 02:50 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
1 sibling, 1 reply; 15+ messages in thread
From: Adrian Klaver @ 2023-08-23 02:50 UTC (permalink / raw)
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; umair.shahid@gmail.com; +Cc: pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Re: Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-08-23 02:57 ` Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 03:39 ` Re: [EXTERNAL] Re: Oracle FDW version Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 15+ messages in thread
From: Jethro Elmer Sanidad @ 2023-08-23 02:57 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: umair.shahid@gmail.com; pgsql-general@lists.postgresql.org
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: 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.
Attachments:
image.png (image/png, 73.8K) download
view image
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-08-23 03:31 ` Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
1 sibling, 1 reply; 15+ messages in thread
From: Christophe Pettus @ 2023-08-23 03:31 UTC (permalink / raw)
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; umair.shahid@gmail.com; pgsql-general@lists.postgresql.org
> 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 to upgrade your server to something in-support.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
@ 2023-08-23 06:04 ` Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
0 siblings, 1 reply; 15+ messages in thread
From: Ian Lawrence Barwick @ 2023-08-23 06:04 UTC (permalink / raw)
To: Christophe Pettus <xof@thebuild.com>; +Cc: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; Adrian Klaver <adrian.klaver@aklaver.com>; umair.shahid@gmail.com; pgsql-general@lists.postgresql.org
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 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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
@ 2023-08-23 06:10 ` Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 06:21 ` Re: [EXTERNAL] Oracle FDW version Justin Clift <justin@postgresql.org>
2023-08-23 11:07 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 15:04 ` Re: [EXTERNAL] Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 3 replies; 15+ messages in thread
From: Jethro Elmer Sanidad @ 2023-08-23 06:10 UTC (permalink / raw)
To: Ian Lawrence Barwick <barwick@gmail.com>; +Cc: Christophe Pettus <xof@thebuild.com>; Adrian Klaver <adrian.klaver@aklaver.com>; umair.shahid@gmail.com; pgsql-general@lists.postgresql.org
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 <barwick@gmail.com>
wrote:
> 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 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.
Attachments:
image.png (image/png, 73.8K) download
view image
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-08-23 06:21 ` Justin Clift <justin@postgresql.org>
2 siblings, 0 replies; 15+ messages in thread
From: Justin Clift @ 2023-08-23 06:21 UTC (permalink / raw)
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; +Cc: pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-08-23 11:07 ` Ian Lawrence Barwick <barwick@gmail.com>
2 siblings, 0 replies; 15+ messages in thread
From: Ian Lawrence Barwick @ 2023-08-23 11:07 UTC (permalink / raw)
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; +Cc: Christophe Pettus <xof@thebuild.com>; Adrian Klaver <adrian.klaver@aklaver.com>; umair.shahid@gmail.com; pgsql-general@lists.postgresql.org
2023年8月23日(水) 15:10 Jethro Elmer Sanidad <jethroelmersanidad@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 <barwick@gmail.com>
> wrote:
>
>> 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 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.
>
Attachments:
image.png (image/png, 73.8K) download
view image
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-08-23 15:04 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-24 07:24 ` Re: [EXTERNAL] Oracle FDW version Adam Lee <adlee@vmware.com>
2 siblings, 1 reply; 15+ messages in thread
From: Adrian Klaver @ 2023-08-23 15:04 UTC (permalink / raw)
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; Ian Lawrence Barwick <barwick@gmail.com>; +Cc: Christophe Pettus <xof@thebuild.com>; umair.shahid@gmail.com; pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 15:04 ` Re: [EXTERNAL] Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-08-24 07:24 ` Adam Lee <adlee@vmware.com>
2023-09-01 03:05 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
0 siblings, 1 reply; 15+ messages in thread
From: Adam Lee @ 2023-08-24 07:24 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; Ian Lawrence Barwick <barwick@gmail.com>; +Cc: Christophe Pettus <xof@thebuild.com>; umair.shahid@gmail.com <umair.shahid@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
The original poster was building against Greenplum 6, it’s expected to fail.
Try this https://github.com/adam8157/oracle_fdw_greenplum, it’s not based on the lasts oracle_fdw, but likely easy to rebase.
From: Adrian Klaver <adrian.klaver@aklaver.com>
Date: Thursday, August 24, 2023 at 15:19
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>, Ian Lawrence Barwick <barwick@gmail.com>
Cc: Christophe Pettus <xof@thebuild.com>, umair.shahid@gmail.com <umair.shahid@gmail.com>, pgsql-general@lists.postgresql.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
> (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
!! External Email: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 15:04 ` Re: [EXTERNAL] Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-24 07:24 ` Re: [EXTERNAL] Oracle FDW version Adam Lee <adlee@vmware.com>
@ 2023-09-01 03:05 ` Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-09-04 05:16 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
0 siblings, 1 reply; 15+ messages in thread
From: Jethro Elmer Sanidad @ 2023-09-01 03:05 UTC (permalink / raw)
To: Adam Lee <adlee@vmware.com>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; Ian Lawrence Barwick <barwick@gmail.com>; Christophe Pettus <xof@thebuild.com>; umair.shahid@gmail.com <umair.shahid@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hello,
I already installed your extension. As of now, I'm having issues in
creating the oracle_fdw. Please advise. Thanks!
postgres=# create extension oracle_fdw;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a
distributed table
postgres=#
On Thu, Aug 24, 2023 at 3:24 PM Adam Lee <adlee@vmware.com> wrote:
> The original poster was building against Greenplum 6, it’s expected to
> fail.
>
>
>
> Try this https://github.com/adam8157/oracle_fdw_greenplum, it’s not based
> on the lasts oracle_fdw, but likely easy to rebase.
>
>
>
> *From: *Adrian Klaver <adrian.klaver@aklaver.com>
> *Date: *Thursday, August 24, 2023 at 15:19
> *To: *Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>, Ian
> Lawrence Barwick <barwick@gmail.com>
> *Cc: *Christophe Pettus <xof@thebuild.com>, umair.shahid@gmail.com <
> umair.shahid@gmail.com>, pgsql-general@lists.postgresql.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
> > (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
>
>
>
>
>
>
> !! External Email: This email originated from outside of the organization.
> Do not click links or open attachments unless you recognize the sender.
>
--
[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.
Attachments:
image.png (image/png, 73.8K) download
view image
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 15:04 ` Re: [EXTERNAL] Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-24 07:24 ` Re: [EXTERNAL] Oracle FDW version Adam Lee <adlee@vmware.com>
2023-09-01 03:05 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-09-04 05:16 ` Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-09-04 14:31 ` Re: [EXTERNAL] Oracle FDW version Adam Lee <adlee@vmware.com>
0 siblings, 1 reply; 15+ messages in thread
From: Jethro Elmer Sanidad @ 2023-09-04 05:16 UTC (permalink / raw)
To: Adam Lee <adlee@vmware.com>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; Ian Lawrence Barwick <barwick@gmail.com>; Christophe Pettus <xof@thebuild.com>; umair.shahid@gmail.com <umair.shahid@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Hello,
I already installed your extension. As of now, I'm having issues in
creating the oracle_fdw. Please advise. Thanks!
postgres=# create extension oracle_fdw;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a
distributed table
postgres=#
On Fri, Sep 1, 2023 at 11:05 AM Jethro Elmer Sanidad <
jethroelmersanidad@gardenia.com.ph> wrote:
> Hello,
>
> I already installed your extension. As of now, I'm having issues in
> creating the oracle_fdw. Please advise. Thanks!
>
> postgres=# create extension oracle_fdw;
> ERROR: query plan with multiple segworker groups is not supported
> HINT: likely caused by a function that reads or modifies data in a
> distributed table
> postgres=#
>
> On Thu, Aug 24, 2023 at 3:24 PM Adam Lee <adlee@vmware.com> wrote:
>
>> The original poster was building against Greenplum 6, it’s expected to
>> fail.
>>
>>
>>
>> Try this https://github.com/adam8157/oracle_fdw_greenplum, it’s not
>> based on the lasts oracle_fdw, but likely easy to rebase.
>>
>>
>>
>> *From: *Adrian Klaver <adrian.klaver@aklaver.com>
>> *Date: *Thursday, August 24, 2023 at 15:19
>> *To: *Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>, Ian
>> Lawrence Barwick <barwick@gmail.com>
>> *Cc: *Christophe Pettus <xof@thebuild.com>, umair.shahid@gmail.com <
>> umair.shahid@gmail.com>, pgsql-general@lists.postgresql.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
>> > (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
>>
>>
>>
>>
>>
>>
>> !! External Email: This email originated from outside of the
>> organization. Do not click links or open attachments unless you recognize
>> the sender.
>>
>
>
> --
>
> [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
>
--
[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.
Attachments:
image.png (image/png, 73.8K) download
view image
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Re: [EXTERNAL] Oracle FDW version Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Re: [EXTERNAL] Oracle FDW version Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 15:04 ` Re: [EXTERNAL] Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-24 07:24 ` Re: [EXTERNAL] Oracle FDW version Adam Lee <adlee@vmware.com>
2023-09-01 03:05 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-09-04 05:16 ` Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-09-04 14:31 ` Adam Lee <adlee@vmware.com>
0 siblings, 0 replies; 15+ messages in thread
From: Adam Lee @ 2023-09-04 14:31 UTC (permalink / raw)
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; Ian Lawrence Barwick <barwick@gmail.com>; Christophe Pettus <xof@thebuild.com>; umair.shahid@gmail.com <umair.shahid@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
That warning is misleading while creating extensions. Check the runtime linking of oracle_fdw.so,
probably some dependencies are missing. Greenplum failed to detect such issues and errored out
at a wrong place.
Since it’s an issue only happens on Greenplum, please continue the discussion off the mailing list.
From: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
Date: Monday, September 4, 2023 at 13:17
To: Adam Lee <adlee@vmware.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, Ian Lawrence Barwick <barwick@gmail.com>, Christophe Pettus <xof@thebuild.com>, umair.shahid@gmail.com <umair.shahid@gmail.com>, pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: [EXTERNAL] Oracle FDW version
!! External Email
Hello,
I already installed your extension. As of now, I'm having issues in creating the oracle_fdw. Please advise. Thanks!
postgres=# create extension oracle_fdw;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a distributed table
postgres=#
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [EXTERNAL] Re: Oracle FDW version
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:50 ` Re: Oracle FDW version Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Re: [EXTERNAL] Re: Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
@ 2023-08-23 03:39 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 15+ messages in thread
From: Tom Lane @ 2023-08-23 03:39 UTC (permalink / raw)
To: Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; umair.shahid@gmail.com; pgsql-general@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2023-09-04 14:31 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-23 02:25 Oracle FDW version Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 02:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-08-23 02:50 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-23 02:57 ` Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 03:31 ` Christophe Pettus <xof@thebuild.com>
2023-08-23 06:04 ` Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 06:10 ` Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-08-23 06:21 ` Justin Clift <justin@postgresql.org>
2023-08-23 11:07 ` Ian Lawrence Barwick <barwick@gmail.com>
2023-08-23 15:04 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-24 07:24 ` Adam Lee <adlee@vmware.com>
2023-09-01 03:05 ` Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-09-04 05:16 ` Jethro Elmer Sanidad <jethroelmersanidad@gardenia.com.ph>
2023-09-04 14:31 ` Adam Lee <adlee@vmware.com>
2023-08-23 03:39 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox