Re: NOWAIT doesn't work - Mailing list pgsql-hackers

From Szymon Guz
Subject Re: NOWAIT doesn't work
Date
Msg-id CAFjNrYt9g6iAeA65JTKJCT7s2iiBhQJG3qX5tTjhQSy+Fjsa1w@mail.gmail.com
Whole thread Raw
In response to Re: NOWAIT doesn't work  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers


On 31 October 2012 14:52, Pavel Stehule <pavel.stehule@gmail.com> wrote:
tested on 9.3

Pavel

2012/10/31 Pavel Stehule <pavel.stehule@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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: NOWAIT doesn't work
Next
From: Christian Kruse
Date:
Subject: Re: NOWAIT doesn't work