| From: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
|---|---|
| To: | Trang Le <trang(dot)le(at)evizi(dot)com> |
| Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Autocommit for multi call procedure |
| Date: | 2021-09-20 05:08:04 |
| Message-ID: | CAM9w-_kcNik7QrrBvqN115CyMvuFNnNf9YcV_STQ6CcpEcmf2A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers pgadmin-support |
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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aditya Toshniwal | 2021-09-20 05:32:17 | Re: Autocommit for multi call procedure |
| Previous Message | Akshay Joshi | 2021-09-17 15:37:56 | Re: [pgAdmin][RM-6723]: Change indicator color of query row error. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aditya Toshniwal | 2021-09-20 05:32:17 | Re: Autocommit for multi call procedure |
| Previous Message | Aditya Toshniwal | 2021-09-20 04:46:35 | Re: Users Management |