On Oct 26, 2006, at 18:45, Tom Lane wrote:
> log_min_error_statement = error would at least get you the statements
> reporting the deadlocks, though not what they're conflicting against.
Would it be possible (in 8.3, say) to log the conflicting backend's
current statement (from pg_stat_activity, perhaps)? I guess the
conflicting backend would currently be waiting for a lock, so its
current query (before releasing the lock) is the one we want.
Thanks!
- Chris