Postgres Pro
Downloads
Home   >   mailing lists

Re: autocommit for multi call store procedure - Mailing list pgsql-general

From Ninad Shah
Subject Re: autocommit for multi call store procedure
Date
Msg-id CAOFEiBdWVH0qiU4k98eykuVQFPFQrJMWRywE1XX0a-cEJNWhvQ@mail.gmail.com
Whole thread Raw
In response to autocommit for multi call store procedure  (Trang Le <trang.le@evizi.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Trang Le
Date:
Subject: autocommit for multi call store procedure
Next
From: Edson Carlos Ericksson Richter
Date:
Subject: Re: The tragedy of SQL