On 8/28/21 11:40 PM, Trang Le wrote:
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;
Is there any error message thrown? If there is, can you tell us?
Is autocommit on? What does the log say?
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.
What does the phrase "the script above doesn't complete" mean?
How do you know that the script doesn't complete? Is the script
hanging? Furthermore, what is the software version? What platform
are you using?
Could you help me on this issue?
Insufficient data for a meaningful answer.
Thanks all.
Regards,
Trang
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
