Home > mailing lists

Thread: Postgres hangs for the query "lock table in exclusive mode"

From

Vinodh NV

Date:

23 February 2018, 10:43:01

Hi,

Postgres hangs for the query "lock table <Tablename> in exclusive mode"

Can you please let me know what could be the reason and how to resolve it?

Regards,

Vinodh.

From

"David G. Johnston"

Date:

23 February 2018, 11:58:48

On Thursday, February 22, 2018, Vinodh NV <linktovinodh@gmail.com> wrote:

Postgres hangs for the query "lock table <Tablename> in exclusive mode"
Can you please let me know what could be the reason and how to resolve it?

Not readily, but that's why the pg_locks view exists.

David J.