Re: autocommit for multi call store procedure

From: Ninad Shah <nshah(dot)postgres(at)gmail(dot)com>
To: Trang Le <trang(dot)le(at)evizi(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: autocommit for multi call store procedure
Date: 2021-09-16 07:38:30
Message-ID: CAOFEiBdWVH0qiU4k98eykuVQFPFQrJMWRywE1XX0a-cEJNWhvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)le(at)evizi(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Carlos Ericksson Richter 2021-09-16 13:24:07 Re: The tragedy of SQL
Previous Message Trang Le 2021-09-16 07:36:32 autocommit for multi call store procedure