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
Hi there,
Sorry I repeat a problem which concerned me since two months, but I got no
answer. It's not clear for me whether it is trivial or without a solution. I
promisse not to repeat it in the future if I will give no answer this time
too.
So, I'm working with "PostgreSQL 8.2.3 on i686-redha
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
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
