Hi, On Wednesday, October 31, 2012 02:51:38 PM Pavel Stehule wrote: > 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 ....
Yes, I think so. From the documentation: Note that NOWAIT applies only to the row-level lock(s) (http://www.postgresql.org/docs/9.2/static/sql-select.html) Greetings, CK -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
