Обсуждение: Deadlock Detected

Is there a setting that will give me a more verbose log message when a deadlock is detected?

currently, i just get "Error: Deadlock Detected" but it doesn't tell me the tables involved.

Thanks

Dave

On Thu, Feb 11, 2010 at 4:50 PM, David Kerr <dmk@mr-paradox.net> wrote:
> currently, i just get "Error: Deadlock Detected" but it doesn't tell me the tables involved.
>

Where do you see this?  The postgres log file surely has more details.
 Also, what version etc. etc.

On Thu, Feb 11, 2010 at 05:01:37PM -0500, Vick Khera wrote:
- On Thu, Feb 11, 2010 at 4:50 PM, David Kerr <dmk@mr-paradox.net> wrote:
- > currently, i just get "Error: Deadlock Detected" but it doesn't tell me the tables involved.
- >
-
- Where do you see this?  The postgres log file surely has more details.
-  Also, what version etc. etc.

you're right, my mistake. Plenty of info in the log (where I was looking, but not closely enough).

thanks

Dave