Re: support for MERGE

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: support for MERGE
Дата
Msg-id 20220801145257.GA15006@telsasoft.com
обсуждение исходный текст
Ответ на Re: support for MERGE  (Álvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: support for MERGE  (Álvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
On Tue, Jun 14, 2022 at 11:27:06AM +0200, Álvaro Herrera wrote:
> @@ -448,9 +448,9 @@ COMMIT;
>      and execute the first one that succeeds.
>      If <command>MERGE</command> attempts an <command>INSERT</command>
>      and a unique index is present and a duplicate row is concurrently
> -    inserted, then a uniqueness violation is raised.
> -    <command>MERGE</command> does not attempt to avoid the
> -    error by executing an <command>UPDATE</command>.
> +    inserted, then a uniqueness violation error is raised;
> +    <command>MERGE</command> does not attempt to avoid such
> +    errors by evaluating <literal>MATCHED</literal> conditions.

This was a portion of a chang that was committed as ffffeebf2.

But I don't understand why this changed from "does not attempt to avoid the
error by executing an <command>UPDATE</command>." to "...by evaluating
<literal>MATCHED</literal> conditions."

Maybe it means to say "..by re-starting evaluation of match conditions".

Sorry to re-raise this 6 weeks later..

-- 
Justin



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

Предыдущее
От: Japin Li
Дата:
Сообщение: Re: Typo in pg_db_role_setting.h
Следующее
От: Dong Wook Lee
Дата:
Сообщение: Re: Add test of pg_prewarm extenion