Re: autocommit for multi call store procedure

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Trang Le <trang(dot)le(at)evizi(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: autocommit for multi call store procedure
Date: 2021-09-16 14:21:04
Message-ID: ea6b7f85-2fc0-e999-3ccc-ca5b17c5169b@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/16/21 12:36 AM, Trang Le 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?

Maybe but will need to see:

1) The content of the procedures.

2) The manner in which they are called.

3) The actual complete error message.

>
> Thanks,
> Trang

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2021-09-16 14:31:49 Re: The tragedy of SQL
Previous Message Edson Carlos Ericksson Richter 2021-09-16 13:24:07 Re: The tragedy of SQL