| From: | Szymon Guz <mabewlun(at)gmail(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: NOWAIT doesn't work |
| Date: | 2012-10-31 13:57:39 |
| Message-ID: | CAFjNrYt9g6iAeA65JTKJCT7s2iiBhQJG3qX5tTjhQSy+Fjsa1w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 31 October 2012 14:52, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> tested on 9.3
>
> Pavel
>
> 2012/10/31 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Kruse | 2012-10-31 13:59:35 | Re: NOWAIT doesn't work |
| Previous Message | Andres Freund | 2012-10-31 13:56:30 | Re: NOWAIT doesn't work |