Oops! You are right. It was not a dead-lock.
I let the process to continue and after about one hour I got in the log the
following message 'cannot have more than 2^32-1 commands in a transaction'.
After some investigations in the code I found an infinite loop.
Thanks and sorry for wasting time,
S
"Sabin Coanda" <[EMAIL PROTECTED]> writes:
> 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 tables?
Are you sure they are in the same database you are workin
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
