On Fri, Sep 21, 2012 at 7:43 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:
> Has there been any discussion regarding adding a time-limited version of
> NOWAIT, say: “WAITONLY 50” (milliseconds), when dealing the explicit LOCK
> TABLE or the SELECT…FOR(SHARE|UPDATE) commands?
I think you could do this by issuing
SET statement_timeout = 50;
and then attempting the LOCK TABLE or SELECT ... FOR UPDATE command,
without NOWAIT. You'll either get an "ERROR: canceling statement due
to statement timeout" or the command should succeed.
Josh