On Mon, Nov 9, 2009 at 9:48 AM, digitaldeath <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
