Insert statement doesn't complete

From: Trang Le <trang(dot)le(at)evizi(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Insert statement doesn't complete
Date: 2021-08-29 03:40:46
Message-ID: CAFfZjTjMwWxNtVutKVb7AWVdgKEEhgy6_0Y8zZVTa7Oxd9t=QA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2021-08-29 03:51:08 Re: Insert statement doesn't complete
Previous Message Adrian Klaver 2021-08-28 22:35:20 Re: use fopen unknown resource