Postgres Pro
Downloads
Home   >   mailing lists

Re: Autocommit for multi call procedure - Mailing list pgadmin-support

From Aditya Toshniwal
Subject Re: Autocommit for multi call procedure
Date
Msg-id CAM9w-_kcNik7QrrBvqN115CyMvuFNnNf9YcV_STQ6CcpEcmf2A@mail.gmail.com
Whole thread Raw
In response to Autocommit for multi call procedure  (Trang Le <trang.le@evizi.com>)
Responses Re: Autocommit for multi call procedure  (Michael Shapiro <mshapiro51@gmail.com>)
List pgadmin-support
Tree view
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?

image.png

image.png

Regards,
Trang


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"
Attachment

pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: Users Management
Next
From: Michael Shapiro
Date:
Subject: Re: Autocommit for multi call procedure