feature request - update nowait - Mailing list pgsql-general

From Eduardo Piombino
Subject feature request - update nowait
Date
Msg-id CAGHqW7-1kn7A+zrYqMdNpnD3NdwEwt=7Q1YD8AKGfdc6R4Ev8A@mail.gmail.com
Whole thread Raw
Responses Re: feature request - update nowait
Re: feature request - update nowait
Re: feature request - update nowait
List pgsql-general
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.

Best regards,
Eduardo.

pgsql-general by date:

Previous
From: Chetan Suttraway
Date:
Subject: Re: Select Output in XML format
Next
From: Simon Riggs
Date:
Subject: Re: feature request - update nowait