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, Sabin -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
