On Thu, Sep 8, 2011 at 10:01 AM, Eduardo Piombino <drak...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
