Re: [PATCHES] [pgsql-patches] Phantom Command IDs, updated patch

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: [PATCHES] [pgsql-patches] Phantom Command IDs, updated patch
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57901C13306@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: [PATCHES] [pgsql-patches] Phantom Command IDs, updated patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PATCHES] [pgsql-patches] Phantom Command IDs, updated patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> As for what I think we *should* do near-term, I'm pretty strongly
> tempted to suggest that we just throw an error if a subtransaction
tries
> to upgrade an upper transaction's shared lock to exclusive.

So when a RI check locks a parent, you would not be able to update the
parent
in a later subtrans.
I can imagine, that the error would be a problem in a select for update
loop,
because there you usually want to update the row.

Andreas


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [PATCHES] [pgsql-patches] Phantom Command IDs,updated patch
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Add lock matrix to documentation.