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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
