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