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
