autocommit for multi call store procedure

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. C

calling store procedure / insert statement never complete

Hi Mladen, I missed previous emails, so I am creating a new one. I think the problem is coming from front-end side. when I run store procedure, job in pg_locks is done, data is inserted, log table shows that job completed with number of insert. However, store procedure in front-end side is still

Insert statement doesn't complete

Hi all, I am facing an issue. when I run a script: INSERT INTO mdm.etl_exception_info SELECT * FROM mdm.etl_exception_info_vw2; after running script I check this script in pg_lock, everything ok, job done, data is inserted. However, the session contains the script above doesn't complete t