Обсуждение: Postgres hangs for the query "lock table in exclusive mode"

Поиск

Список

Период

Сортировка

От

Vinodh NV

Дата:

23 февраля 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.

От

"David G. Johnston"

Дата:

23 февраля 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.