Brian McNally <bmcna...@uw.edu> writes:
> Ok, I'm running with all available updates and kernel 2.6.18-308.4.1.el5
> but am still having the same problem.
It's fairly clearly blocked on a lock ... have you looked into the
pg_locks view to see what is holding the lock?
(I'm wondering about a prepared transaction, myself. There isn't much
else that could hold a lock across a server restart.)
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
