Re: feature request - update nowait

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(dot)p(at)gmail(dot)com>

> Try a command LOCK NOWAIT
>
> 2011/9/8, Eduardo Piombino <drakorg(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>