Search Postgresql Archives

Re: [EXTERNAL] Oracle FDW version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxx> 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@xxxxxxxxxxx>
Date: Thursday, August 24, 2023 at 15:19
To: Jethro Elmer Sanidad <jethroelmersanidad@xxxxxxxxxxxxxxx>, Ian Lawrence Barwick <barwick@xxxxxxxxx>
Cc: Christophe Pettus <xof@xxxxxxxxxxxx>, umair.shahid@xxxxxxxxx <umair.shahid@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxx






!! External Email: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender.



--

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



--

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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux