Lock table, Select for update and Serialization error

Поиск
Список
Период
Сортировка
От sudhir
Тема Lock table, Select for update and Serialization error
Дата
Msg-id 4651E1C8.2040902@cse.iitb.ac.in
обсуждение исходный текст
Список pgsql-general
Hi,

As per postgres docs, 'Select for update' is used to obtain row level
locks where as 'lock table' is used to obtain table level locks.

Under serializable isolation level, select for update gives error if
rows selected have been modified concurrently.
but 'lock table' does not give such error even though some of the rows
in the table are modified by concurrent transaction.

Is this the expected behavior?






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

Предыдущее
От: "CAJ CAJ"
Дата:
Сообщение: Re: Perl + Determine active connections on Pg 8.0.x and Pg 8.2.x
Следующее
От: PFC
Дата:
Сообщение: feature suggestions