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

From Adrian Klaver
Subject Re: autocommit for multi call store procedure
Date
Msg-id ea6b7f85-2fc0-e999-3ccc-ca5b17c5169b@aklaver.com
Whole thread Raw
In response to autocommit for multi call store procedure  (Trang Le <trang.le@evizi.com>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Edson Carlos Ericksson Richter
Date:
Subject: Re: The tragedy of SQL
Next
From: Merlin Moncure
Date:
Subject: Re: The tragedy of SQL