On Wednesday, October 31, 2012 02:51:38 PM Pavel Stehule wrote: > 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 ....
NOWAIT is about row level locks, not about table level locks. Andres -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
