I'm sorry, isn't it meant for table locks? I was talking about row level locking.
Eduardo 2011/9/8 pasman pasmański <pasma...@gmail.com> > Try a command LOCK NOWAIT > > 2011/9/8, Eduardo Piombino <drak...@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 >
