Insert statement doesn't complete

On Saturday, August 28, 2021, Trang Le <trang.le@evizi.com> wrote:

after running script

How?

I check this script in pg_lock, everything ok, job
done, data is inserted.

You can tell this from pg_lock?

However, the session

Where is this session?

David J.

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