Re: Lock table, Select for update and Serialization error

Поиск
Список
Период
Сортировка
От sudhir
Тема Re: Lock table, Select for update and Serialization error
Дата
Msg-id 4653C842.8020209@cse.iitb.ac.in
обсуждение исходный текст
Ответ на Re: Lock table, Select for update and Serialization error  ("Joris Dobbelsteen" <Joris@familiedobbelsteen.nl>)
Список pgsql-general
> Summarizing:
> * Lock table - High-level: executes fast, but concurrency problems.
> Guarentees about future changes.
> Select for update - Low-level, concurrent, ensures data validity and
> indicates its modified shortly.
> Select for share - Low-level, concurrent, ensures data validity.
>
> Hopefully this clears it up a bit.
>
Yeah, it does. Thanks for your help guys.

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

Предыдущее
От: Ben
Дата:
Сообщение: Re: Integrity on large sites
Следующее
От: PFC
Дата:
Сообщение: Re: Using a trigger with an object-relational manager