Re: [BUGS] BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command

2012-03-21 Thread Tom Lane
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 b

Re: [BUGS] BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command

2012-03-21 Thread Kevin Grittner
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 > --- > start transaction;

[BUGS] BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command

2012-03-21 Thread neeraj . punmiya
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 =