Re: WaitOnLock error - what does this mean? - Mailing list pgsql-general

From Tom Lane
Subject Re: WaitOnLock error - what does this mean?
Date
Msg-id 23098.964416416@sss.pgh.pa.us
Whole thread Raw
In response to Re: WaitOnLock error - what does this mean?  ("Robert B. Easter" <reaster@comptechnews.com>)
Responses Re: WaitOnLock error - what does this mean?
List pgsql-general
"Robert B. Easter" <reaster@comptechnews.com> writes:
> Is my database design flawed if this occurs?

The db layout is probably not the issue, but I'd say your scripts are
flawed.

The usual recipe for avoiding deadlocks is pretty simple: all acquirers
of locks must grab the locks in the same order.

            regards, tom lane

pgsql-general by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: WaitOnLock error - what does this mean?
Next
From: "Robert B. Easter"
Date:
Subject: Is there any way to speed up PL/TCL functions?