Re: Request for resolution || Support

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: Request for resolution || Support
Дата
Msg-id CAJGNTeOdNu5nw2b_01OwpHeg8XvaMBJJucsBvNEQ755PWL6f_g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Request for resolution || Support  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения




El dom., 21 de jul. de 2019 3:48 p. m., David G. Johnston <david.g.johnston@gmail.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.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

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

В списке pgsql-bugs по дате отправления: