Re: NOWAIT doesn't work

2012/10/31 Alvaro Herrera <alvherre@2ndquadrant.com>:
> Alvaro Herrera escribió:
>
>> Now, is this the right behavior?  I'm not sure.  But I know for certain
>> that making it behave as you expect is very tricky.  The table lock is
>> grabbed during parse analysis; we'd have to postpone grabbing the lock
>> until after we have had the chance to notice that there's a FOR UPDATE
>> clause for the table with a NOWAIT option attached.
>
> Furthermore you could do it manually: just do a LOCK TABLE NOWAIT in the
> second session before the SELECT FOR UPDATE.

I understand now, thank you to all for information

Regards

Pavel

>
> --
> Álvaro Herrera                http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services