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
neeraj.punm...@securetogether.com wrote:
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
---
neeraj.punm...@securetogether.com writes:
First database session:
---
Lock table Test;
Second database session
---
Select y from Test where x=1 for update nowait;
select query waits until first session releases table lock.
This isn't a bug.