Re: WaitOnLock error - what does this mean?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WaitOnLock error - what does this mean?
Date: 2000-07-24 05:26:56
Message-ID: 23098.964416416@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Robert B. Easter" <reaster(at)comptechnews(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-07-24 06:04:57 Re: Is there any way to speed up PL/TCL functions?
Previous Message Robert B. Easter 2000-07-24 05:15:00 Is there any way to speed up PL/TCL functions?