Insert statement doesn't complete

[Trang Le]

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 though data is inserted and job done that is verified in
pg_lock.

Could you help me on this issue?

Thanks all.

Regards,
Trang

calling store procedure / insert statement never complete

[Trang Le]

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 show running until the sever closed connection. The same
problem when I run the query statement only, insert about 190k rows, when
check target table, data is insert, but in the front-end side is still show
wait until server close connection.

I use pgamin4 5.3.

Error: Server closed the connection unexpectedly. This probably means the
server terminated abnormally before or while processing the request.

Could you please double check?

Thanks and regards,
Trang

autocommit for multi call store procedure

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

Could you help me on this issue?

Thanks,
Trang