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  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Alexander LAW
Дата:
Сообщение: Re: BUG #6510: A simple prompt is displayed using wrong charset
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command