Re: [GENERAL] deadlock error messages

2008-03-21 Thread Craig Ringer
dan chak wrote: What would be really great would be to know what the other query is, as opposed to just the pid (not sure from this output if it's 4483 or 29245). Also not sure if this is the right list for this. But potentially someone on here may have a good tip on debugging deadlocking?

[GENERAL] deadlock error messages

2008-03-21 Thread dan chak
When there's a deadlock detected, the error message recorded in the log prints out the query being aborted, and the process id of the other transaction involved in the deadlock. It would be great if more context was printed for the other query (e.g. the query itself), as opposed to just th