Thread: Re: Autocommit for multi call procedure

Hi Aditya,

I tried in psql and it works as expected. 

Can you double check on this case, I already check autocommit is true.

Thanks & regards,

Trang

On Mon, Sep 20, 2021 at 12:08 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

Hi Trang,

Can you try calling the same from the PSQL tool - https://www.pgadmin.org/docs/pgadmin4/5.7/psql_tool.html if it works ?

Query tool runs queries wrapped inside BEGIN and END. Maybe that is causing the issue.

On Fri, Sep 17, 2021 at 12:20 PM Trang Le <trang.le@evizi.com> wrote:

Hi guys,

I am trying to call 2 stored procedures in a run command that has commit statement. However, I received an error 'Invalid transaction termination'. Could you help me on this issue?

Regards,

Trang

--

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Software Architect | edbpostgres.com

"Don't Complain about Heat, Plant a TREE"