The following bug has been logged on the website: Bug reference: 6548 Logged by: Neeraj Punmiya Email address: neeraj.punm...@securetogether.com PostgreSQL version: 9.1.3 Operating system: CentOS 6.2 , Windows 7 Description:
Steps to simulate problem ============================ Create Table Test (x integer,y integer); Insert Into Test Values(1,100); Insert Into Test Values(2,200); First database session: --------------------------- start transaction; Lock table Test; Second database session ----------------------- start transaction; Select y from Test where x=1 for update nowait; select query waits until first session releases table lock. Nowait does not have any effect in select statement. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
