Re: WaitOnLock error - what does this mean?

"Robert B. Easter" <reaster@comptechnews.com> writes:
> ERROR: WaitOnLock: error on wakeup - Aborting this transaction

Is there any NOTICE coming out right before that?

For example:

psql #1:

begin;
lock table tenk1;

psql #2:

begin;
lock table tenk2;
lock table tenk1;

<waits>

psql #1:

lock table tenk2;

NOTICE:  Deadlock detected -- See the lock(l) manual page for a possible cause.
ERROR:  WaitOnLock: error on wakeup - Aborting this transaction


Not sure why this isn't just one ERROR, since anyone using a client that
discards NOTICEs is going to be confused...

            regards, tom lane