On Mon, Nov 9, 2009 at 9:48 AM, digitaldeath <digital.death@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