Re: 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;

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