Re: [HACKERS] 'Waiting on lock'

* Simon Riggs (simon@2ndquadrant.com) wrote:
> related TODO items:
> - add a WAIT n clause in same SQL locations as NOWAIT
> - add a lock_wait_timeout (USERSET), default = 0 (unlimited waiting)
>
> to provide better control over lock waits.

I havn't had a chance to look over the commit yet, sorry, but it sounds
like it's only logging to the log file?  Was hoping to get a NOTICE back
out to the user for at least the 'still waiting on lock x' log, after
the deadlock detection.  I'm not particular about gucs/settings/etc,
whatever people feel is best, provided there's a way to get the messages
in psql. :)

    Thanks,

        Stephen