Robert Creager <[EMAIL PROTECTED]> writes:
> Opps, if it helps, the log of the deadlock:
> 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
> proc 18815.
> Aug 10 14:19:36 thunder postgres[18735]: [2-3] Proc 18815 waits for
> AccessExclusiveLock on relation 18101 of database 17140; blocked by proc
> 18735.
What tables do the two referenced OIDs correspond to? Also, which
process was doing what, exactly?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
