Re: support for MERGE

Поиск
Список
Период
Сортировка
От Álvaro Herrera
Тема Re: support for MERGE
Дата
Msg-id e0d96c29-6211-48bb-be50-77af87dbbf76@www.fastmail.com
обсуждение исходный текст
Ответ на support for MERGE  (Ranier Vilela <ranier.vf@gmail.com>)
Ответы Re: support for MERGE
Re: support for MERGE
Список pgsql-hackers
On Wed, Jun 1, 2022, at 5:28 PM, Alvaro Herrera wrote:
> Re-reading the modified paragraph, I propose "see X for a thorough
> explanation on the behavior of MERGE under concurrency".  However, in
> the proposed patch the link goes to Chapter 13 "Concurrency Control",
> and the explanation that we intend to link to is hidden in subsection
> 13.2.1 "Read Committed Isolation level".  So it appears that we do not
> have any explanation on how MERGE behaves in other isolation levels.
> That can't be good ...

OK, here's slightly updated wording for this, after reading the MVCC docs again. I didn't change the link to point
specificallyto read-committed, but I worded the reference to suggest that the referenced explanation is within each
isolationlevel's subsection. In reality, there's not much to say about each specific command in REPEATABLE READ and
SERIALIZABLE,but in the former I added MERGE to the list of commands.
 

I checked the pages for UPDATE and DELETE, to see if they had any explanation of concurrency, to use that as precedent.
Icouldn't find anything. 
Вложения

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