Re: Request for resolution || Support - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Request for resolution || Support
Date
Msg-id CAKFQuwaYoEwkyO6wUVgnGPB9FR1P6U9g3HG6+dTqD9bDjyoi3w@mail.gmail.com
Whole thread Raw
In response to Request for resolution || Support  (jay chauhan <jaychauhan.src@gmail.com>)
Responses Re: Request for resolution || Support  (Thomas Munro <thomas.munro@gmail.com>)
Re: Request for resolution || Support  (Jaime Casanova <jaime.casanova@2ndquadrant.com>)
List pgsql-bugs
Please don’t pick random places to send emails.  This is neither a bug nor a security issue so neither of these lists apply.  The -general list is most appropriate.

On Sunday, July 21, 2019, jay chauhan <jaychauhan.src@gmail.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
 
Good evening!
I am migrating Oracle DB into PostgreSQL. However I am facing some issue in postgreSQL as listed below. 

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


Rewrite your code as instructed

 
Error-2)
ERROR:  schema "utl_http" does not exist

Insufficient data provided to even guess
 
I need urgent help.

Maybe hire an experienced migration company then.

David J.

pgsql-bugs by date:

Previous
From: jay chauhan
Date:
Subject: Request for resolution || Support
Next
From: Thomas Munro
Date:
Subject: Re: Request for resolution || Support