Postgres Pro
Downloads
Home   >   mailing lists

Insert statement doesn't complete - Mailing list pgsql-general

From Trang Le
Subject Insert statement doesn't complete
Date
Msg-id CAFfZjTjMwWxNtVutKVb7AWVdgKEEhgy6_0Y8zZVTa7Oxd9t=QA@mail.gmail.com
Whole thread Raw
Responses Re: Insert statement doesn't complete  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Insert statement doesn't complete  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: use fopen iso-8859-1 resource
Next
From: "David G. Johnston"
Date:
Subject: Re: Insert statement doesn't complete