Postgres Pro
Downloads
Home   >   mailing lists

NOWAIT doesn't work - Mailing list pgsql-hackers

From Pavel Stehule
Subject NOWAIT doesn't work
Date
Msg-id CAFj8pRAOgar_=CvYGhsB=E19Sq0ELMmArf8aPBf4pBETFG57Vg@mail.gmail.com
Whole thread Raw
Responses Re: NOWAIT doesn't work  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: NOWAIT doesn't work  (Andres Freund <andres@2ndquadrant.com>)
Re: NOWAIT doesn't work  (Christian Kruse <cjk+postgres@defunct.ch>)
Re: NOWAIT doesn't work  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Autoanalyze of the autovacuum daemon ...
Next
From: Pavel Stehule
Date:
Subject: Re: NOWAIT doesn't work