Re: Insert statement doesn't complete

2021-08-28 Thread Mladen Gogala
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 runn

Re: Insert statement doesn't complete

2021-08-28 Thread David G. Johnston
On Saturday, August 28, 2021, Trang Le 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.