Re: sequence's plpgsql - Mailing list pgsql-general

From Tom Lane
Subject Re: sequence's plpgsql
Date
Msg-id 8665.1064551440@sss.pgh.pa.us
Whole thread Raw
In response to Re: sequence's plpgsql  (Tim McAuley <mcauleyt@tcd.ie>)
Responses Re: sequence's plpgsql
List pgsql-general
Tim McAuley <mcauleyt@tcd.ie> writes:
> I see from a previous email on the list that someone was able to get
> decent debug out of the locks, i.e.

> Aug 10 14:19:36 thunder postgres[18735]: [2-1] ERROR:  deadlock detected
> Aug 10 14:19:36 thunder postgres[18735]: [2-2] DETAIL:  Proc 18735 waits
> for AccessExclusiveLock on relation 18028 of database 17140; blocked by

> How can I get this?

This display is a new feature in 7.4.  Can you try your problem on a
7.4 beta release?

            regards, tom lane

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: non local access to database
Next
From: zhuangjifeng
Date:
Subject: about catalog!