SELECT FOR UPDATE locks whole table

Поиск
Список
Период
Сортировка
От D'Arcy J.M. Cain
Тема SELECT FOR UPDATE locks whole table
Дата
Msg-id 20021206190303.98BD31BA6@druid.net
обсуждение исходный текст
Ответы Re: SELECT FOR UPDATE locks whole table  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: SELECT FOR UPDATE locks whole table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
We have the following query:

SELECT certificate_id   INTO TEMP TABLE x_certs   FROM certificate   WHERE cert_status = 0 AND       certificate_id
BETWEEN1111 AND 2222 AND       client_id IN (1, 2, 3)   ORDER BY certificate_id   FOR UPDATE;
 

Is there any reason that this query should lock the entire certificate table? Is there something strange because of the
INclause or because it is going 
 
into a temporary table?  This is a production server running 7.2.2 so perhaps 
it is fixed in 7.3.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: order by a "select as" determined by case statement
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: SELECT FOR UPDATE locks whole table