Обсуждение: undefined relations in pg_locks

Поиск
Список
Период
Сортировка

undefined relations in pg_locks

От
"Sabin Coanda"
Дата:
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

Re: undefined relations in pg_locks

От
Guillaume Lelarge
Дата:
Sabin Coanda wrote:
> 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 ?
> 

Maybe they're not objects of the database you're connected to. You need 
to check the "database" column of pg_locks.

Regards.


-- 
Guillaume. http://www.postgresqlfr.org http://dalibo.com