On Mon, Nov 9, 2009 at 9:48 AM, digitaldeath <digital.de...@gmx.it> wrote: > Everybody is doing SELECT only on "adc" table, so why deadlocks if there > are no write attempts on any row?
Well the deadlock error does include the information about what queries deadlocked. In newer versions it includes the full text of the query, but in older versions you would have to check the pg_stat* views or postgres logs to track them down. -- greg -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
