RE: Re: SELECT FOR UPDATE

Поиск
Список
Период
Сортировка
От Andrew Snow
Тема RE: Re: SELECT FOR UPDATE
Дата
Msg-id 000001c12bda$7c30ea90$fa01b5ca@avon
обсуждение исходный текст
Ответ на Re: SELECT FOR UPDATE  ("Gregory Wood" <gregw@com-stock.com>)
Ответы pg_aclcheck: invalid user id #  (jose <jose@sferacarta.com>)
Список pgsql-general
I prefer the way Notes (for example) handles it.  All
records/documents/views are in read-only mode until the user indicates
they actually want to edit.  They then exclusively lock that record for
editing, with optional timeouts (in case their workstation crashes or
whatever).

This turns out to work well in many situations where you realise the
number of times you want to edit compared to the number of times you
want to view, is quite small.  Stops users having to worry whether
anyone else is editing the record at the same time - the system simply
won't let them - no loss of data.



Andrew





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

Предыдущее
От: Mike Mascari
Дата:
Сообщение: SQL Debugging Aide
Следующее
От: wsheldah@lexmark.com
Дата:
Сообщение: How do I drop or change a foreign key?