Re: Request for resolution || Support

El dom., 21 de jul. de 2019 3:48 p. m., David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> escribió:

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

Actually in postgres 11 you can begin/end transactions inside a plpgsql
stored procedure (not in a function)

--
Jaime Casanova
2ndQuadrant
Su diligente equipo de expertos en PostgreSQL