Postgres Pro
Downloads
Home   >   mailing lists

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

From jay chauhan
Subject Request for resolution || Support
Date
Msg-id CA+13ir0wdmLiSoz-KMNp2JE3ze7T1bbH6O3n7VbaKH+Z+qcd6A@mail.gmail.com
Whole thread Raw
Responses Re: Request for resolution || Support  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view

Dear Team,

<<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">>

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

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

I need urgent help.


Thanks,
Jay Chauhan

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: User mapping: view over a foreign table
Next
From: "David G. Johnston"
Date:
Subject: Re: Request for resolution || Support