Re: support for MERGE

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: support for MERGE
Дата
Msg-id 202111122313.fjhecfq6yi2v@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: support for MERGE  (Zhihong Yu <zyu@yugabyte.com>)
Ответы Re: support for MERGE  (Zhihong Yu <zyu@yugabyte.com>)
Список pgsql-hackers
On 2021-Nov-12, Zhihong Yu wrote:

> Hi,
> 
> +           skipped_path = total - insert_path - update_path - delete_path;
> 
> Should there be an assertion that skipped_path is not negative ?

Hm, yeah, added.

> +    * We maintain separate transaction tables for UPDATE/INSERT/DELETE since
> +    * MERGE can run all three actions in a single statement. Note that UPDATE
> +    * needs both old and new transition tables
> 
> Should the 'transaction' in the first line be transition ?

Oh, of course.

Uploaded fixup commits to
https://github.com/alvherre/postgres/commits/merge-15

-- 
Álvaro Herrera              Valdivia, Chile  —  https://www.EnterpriseDB.com/



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: ALTER TABLE DETACH PARTITION violates serializability
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ALTER TABLE DETACH PARTITION violates serializability