undefined relations in pg_locks

Поиск
Список
Период
Сортировка
От Sabin Coanda
Тема undefined relations in pg_locks
Дата
Msg-id focd4k$6bd$1@news.hub.org
обсуждение исходный текст
Ответы Re: undefined relations in pg_locks  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-sql
Hi there,

I have a procedure where a dead-lock occurs, and I'm trying to find the 
tables involved in the lock.

Unfortunatelly, I don't find the related objects of the oids of "relation" 
field. Also all the fields "classid" and "objid" are null.

May I suppose there were references to temporary objects ?
However, how cand I get the related objects involved in this lock ?

TIA,
Sabin 




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

Предыдущее
От:
Дата:
Сообщение: Re: Multiple postgresql functions in a single transaction
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: undefined relations in pg_locks