Re: feature request - update nowait - Mailing list pgsql-general

From Eduardo Piombino
Subject Re: feature request - update nowait
Date
Msg-id CAGHqW7_iGOt9uGhocSL+s8Y7_49YP6PhNseMJNsUyaJ+mMGXzA@mail.gmail.com
Whole thread Raw
In response to Re: feature request - update nowait  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
I'm sorry, isn't it meant for table locks?
I was talking about row level locking.

Eduardo

2011/9/8 pasman pasmański <pasman.p@gmail.com>
Try a command LOCK NOWAIT

2011/9/8, Eduardo Piombino <drakorg@gmail.com>:
> 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.
>


--
------------
pasman

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Eduardo Piombino
Date:
Subject: Re: feature request - update nowait
Next
From: Adrian Klaver
Date:
Subject: Re: PSQLRestore