Re: FOR SHARE vs FOR UPDATE locks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FOR SHARE vs FOR UPDATE locks
Дата
Msg-id 534.1164994846@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: FOR SHARE vs FOR UPDATE locks  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Ответы Re: FOR SHARE vs FOR UPDATE locks  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список pgsql-hackers
Actually ... wait a minute.  The proposed hack covers the case of
SELECT FOR SHARE followed by SELECT FOR UPDATE within a subtransaction.
But what about SELECT FOR SHARE followed by an actual UPDATE (or DELETE)?

We certainly don't want to mark the UPDATE/DELETE as having been carried
out by the upper transaction, but there's no way we can record the
UPDATE while still remembering the previous share-lock.

So I think I'm back to the position that we should throw an error here.
        regards, tom lane


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: 8.2 Beta3-> RC1 upgrade
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: FOR SHARE vs FOR UPDATE locks