Re: autocommit for multi call store procedure

Поиск
Список
Период
Сортировка
От Ninad Shah
Тема Re: autocommit for multi call store procedure
Дата
Msg-id CAOFEiBdWVH0qiU4k98eykuVQFPFQrJMWRywE1XX0a-cEJNWhvQ@mail.gmail.com
обсуждение исходный текст
Ответ на autocommit for multi call store procedure  (Trang Le <trang.le@evizi.com>)
Список pgsql-general
Have you used an EXCEPTION block in the procedure?


Regards,
Ninad Shah

On Thu, 16 Sept 2021 at 13:06, Trang Le <trang.le@evizi.com> wrote:
Hi guys,

I am using pgadmin4 to interact with Postgres database. For now I would like to run 2 store procedure (those have commit statement in begin end block). I enable autocommit and run call 2 store procedures at the same time. However, there is an error with invalid transaction termination.

Could you help me on this issue?

Thanks,
Trang

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

Предыдущее
От: Trang Le
Дата:
Сообщение: autocommit for multi call store procedure
Следующее
От: Edson Carlos Ericksson Richter
Дата:
Сообщение: Re: The tragedy of SQL