Re: Autocommit for multi call procedure

Hi Trang,

Please log the bug here -
https://redmine.postgresql.org/projects/pgadmin4/issues/new for the pgAdmin
team to work on it.

On Mon, Sep 20, 2021 at 10:42 AM Trang Le <trang(dot)le(at)evizi(dot)com> wrote:

> 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(dot)toshniwal(at)enterprisedb(dot)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(dot)le(at)evizi(dot)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: image.png]
>>>
>>> [image: image.png]
>>>
>>> Regards,
>>> Trang
>>>
>>
>>
>> --
>> Thanks,
>> Aditya Toshniwal
>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>> <http://edbpostgres.com>
>> "Don't Complain about Heat, Plant a TREE"
>>
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"