BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command
| От | neeraj.punmiya@securetogether.com | 
|---|---|
| Тема | BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command | 
| Дата | |
| Msg-id | E1SAHyG-0002nj-Hq@wrigleys.postgresql.org обсуждение исходный текст | 
| Ответы | Re: BUG #6548: NOWAIT does not work in Select statement
 if table is locked using "Lock " command Re: BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command | 
| Список | pgsql-bugs | 
The following bug has been logged on the website: Bug reference: 6548 Logged by: Neeraj Punmiya Email address: neeraj.punmiya@securetogether.com PostgreSQL version: 9.1.3 Operating system: CentOS 6.2 , Windows 7 Description:=20=20=20=20=20=20=20=20 Steps to simulate problem =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D 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=3D1 for update nowait; select query waits until first session releases table lock.=20 Nowait does not have any effect in select statement.=20
В списке pgsql-bugs по дате отправления: