Re: feature request - update nowait

On Thu, Sep 8, 2011 at 10:01 AM, Eduardo Piombino <drakorg(at)gmail(dot)com> wrote:
> Hi, would it be possible to implement a nowait modifier to the update
> statement in order to tell it not to wait and raise an error -just like a
> select for update nowait would-, instead of defaulting to waiting forever
> until the lock becomes available?
>
> The lack of such a modifier nowadays forces me to do a select for update
> before every update on which I need the fastest response possible, and it
> would be great if it could be integrated into the command itself.
>
> Just an idea.

Sounds like a good idea.

NOWAIT is outside the SQL Standard anyway. Oracle doesn't support it
either, but that's their loss as well, I think.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services