Re: Fwd: autocommit for multi call store procedure

2021-09-17 Thread Adrian Klaver
On 9/16/21 6:32 PM, Trang Le wrote: Hi Adrian, I am processing this issue with Ninad. Could you double check it? I have no idea what the forwarded message was showing. Too many changes in code. As David suggested reduce this down to a simple test case that demonstrates your issue.

Re: autocommit for multi call store procedure

2021-09-16 Thread David G. Johnston
On Thursday, September 16, 2021, Trang Le wrote > > > Could you double check it? > We’re testing your failing code, not that PostgreSQL is working as intended. Suggest you get rid of all the stuff that doesn’t produce errors and focus on trying to supply a minimal script that produces the

Re: autocommit for multi call store procedure

2021-09-16 Thread Adrian Klaver
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

Re: autocommit for multi call store procedure

2021-09-16 Thread Ninad Shah
Have you used an EXCEPTION block in the procedure? Regards, Ninad Shah On Thu, 16 Sept 2021 at 13:06, 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

autocommit for multi call store procedure

2021-09-16 Thread Trang Le
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.