Dmitri Fuerle wrote:
> A select on the following view hangs the database
> and produces the lock table at the bottom of the message
It doesn't look like it's actually waiting on a lock (unless you managed
to paste only a portion of pg_locks). Are you running on NFS or some
such?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.