From: | jay chauhan <jaychauhan(dot)src(at)gmail(dot)com> |
---|---|
To: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, suchita(dot)dudeja(at)wipro(dot)com, himanshu(dot)jayaswal1(at)wipro(dot)com |
Subject: | Re: Request for resolution || Support |
Date: | 2019-07-24 08:08:30 |
Message-ID: | CA+13ir32gw0ninA5Z9ksS=Uz82+rHvUG3japx_hXvh_LoVPdkg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
Hi Thomas, David/Team,
Thanks you for your response. However we need your confirmation whether my
Error/issue as mentioned below will be resolved if we upgrade our
PostgreSQL Version.
<<My PostgreSQL version : "PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu,
compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit">>
*David response: *Use a newer version
*Tomas response:* Yeah, you should use release 11 for a new project.
My Issue while migrating procedure/function from Oracle to PostgreSQL:
Error-1)
ERROR: cannot begin/end transactions in PL/pgSQL
HINT: Use a BEGIN block with an EXCEPTION clause instead.
CONTEXT: PL/pgSQL function
icmsuatnew.eload_commission_payout_active(text,text,text,text,text,text)
line 486 at SQL statement
SQL state: 0A000
*David Response on it :* Rewrite your code as instructed
Error-2)
ERROR: schema "utl_http" does not exist
LINE 38: L_HTTP_REQUEST UTL_HTTP.REQ;
^
SQL state: 3F000
Character: 1785
*Thomas response: *That's an Oracle thing for doing HTTP requests from
PL/SQL. To do that from plpgsql you could try an extension like this one:
https://github.com/pramsey/pgsql-http
Or you could write your own function in Python or <insert your
favourite PL>. That's what I'd probably do.
https://www.postgresql.org/docs/11/plpython-funcs.html
*Need your urgent help.*
Regards,
Jay Chauhan
+918802766181
On Mon, Jul 22, 2019 at 3:53 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> On Mon, Jul 22, 2019 at 8:49 AM David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> > On Sunday, July 21, 2019, jay chauhan <jaychauhan(dot)src(at)gmail(dot)com> wrote:
> >> <<My PostgreSQL version : "PostgreSQL 9.3.4 on
> x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
> 4.8.5-4), 64-bit">>
> >
> > Use a newer version
>
> Yeah, you should use release 11 for a new project.
>
> https://www.postgresql.org/support/versioning/
>
> >> Error-2)
> >> ERROR: schema "utl_http" does not exist
> >
> > Insufficient data provided to even guess
>
> That's an Oracle thing for doing HTTP requests from PL/SQL. To do
> that from plpgsql you could try an extension like this one:
>
> https://github.com/pramsey/pgsql-http
>
> Or you could write your own function in Python or <insert your
> favourite PL>. That's what I'd probably do.
>
> https://www.postgresql.org/docs/11/plpython-funcs.html
>
> Google should help you find examples of people using plpython to
> access the various Python HTTP modules.
>
> --
> Thomas Munro
> https://enterprisedb.com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Imre Samu | 2019-07-24 09:16:05 | Re: partition table slow planning |
Previous Message | Manuel Rigger | 2019-07-24 07:17:36 | Re: ANALYZE on parent table results in an error "tuple already updated by self" |
From | Date | Subject | |
---|---|---|---|
Next Message | Cyril Champier | 2019-07-24 08:45:01 | Re: Default ordering option |
Previous Message | Dilip Kumar | 2019-07-24 05:35:03 | Re: partition table slow planning |