On 31 October 2012 14:52, Pavel Stehule <pavel.steh...@gmail.com> wrote:
> tested on 9.3 > > Pavel > > 2012/10/31 Pavel Stehule <pavel.steh...@gmail.com>: > > Hello > > > > it is expected behave? > > > > 1.session > > > > postgres=# begin; > > BEGIN > > postgres=# lock oo IN ACCESS EXCLUSIVE MODE; > > LOCK TABLE > > > > 2. session > > > > postgres=# select * from oo for update nowait; > > > > hangs forever .... > > > > Regards > > > > Pavel Stehule > > I've checked on 9.1, works exactly the same. - Szymon