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
Re: SELECT FOR UPDATE locks whole table |
| Список | 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 по дате отправления: