Problems with triggers and table lock

Поиск
Список
Период
Сортировка
От Job
Тема Problems with triggers and table lock
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08180ABD2134@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответы Re: Problems with triggers and table lock  (Alban Hertroys <haramrae@gmail.com>)
Re: Problems with triggers and table lock  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Dear guys,

we are using Postgresql 9.6.1 with Rubyrep in order to replicate some tables across two different, and remote, database
servers.
Since few weeks sometimes when inserting/updating some rows, the statement remains waiting and table seems locked for
insert/updates.

When i issue "select * from pg_stat_activity" no query is locked.
I only obtain this error messages when i kill (i also try directly from bash with pgsql) with "ctrl+c" the locked
insert:

ERROR:  canceling statement due to user request
CONTEXT:  while updating tuple (0,7) in relation "TABLE"
SQL statement "UPDATE TABLE SET FIELD=NOW() WHERE FIELD IS NULL"
PL/pgSQL function TRIGGER_NAME() line 3 at SQL statement

How can i see what is locking my table/tables?

Thank you!
F

В списке pgsql-general по дате отправления:

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: pg data backup from vps
Следующее
От: John R Pierce
Дата:
Сообщение: Re: pg data backup from vps