Re: support for MERGE
От
Alvaro Herrera
Тема
Re: support for MERGE
Дата
Msg-id
202201211537.veim2rt3asdb@alvherre.pgsql
Ответ на
Re: support for MERGE (Japin Li)
Список
Дерево обсуждения
support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: support for MERGE Simon Riggs <simon.riggs@enterprisedb.com>
Re: support for MERGE Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Vik Fearing <vik@postgresfriends.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Daniel Westermann <dwe@dbi-services.com>
Re: support for MERGE Álvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Amit Langote <amitlangote09@gmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Andres Freund <andres@anarazel.de>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Tom Lane <tgl@sss.pgh.pa.us>
Re: support for MERGE Daniel Gustafsson <daniel@yesql.se>
Re: support for MERGE Julien Rouhaud <rjuju123@gmail.com>
Re: support for MERGE Álvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Álvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Álvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Simon Riggs <simon.riggs@enterprisedb.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Amit Langote <amitlangote09@gmail.com>
Re: support for MERGE Amit Langote <amitlangote09@gmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Should use MERGE use BulkInsertState ? Justin Pryzby <pryzby@telsasoft.com>
Re: Should use MERGE use BulkInsertState ? Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Should use MERGE use BulkInsertState ? Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Japin Li <japinli@hotmail.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Japin Li <japinli@hotmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Justin Pryzby <pryzby@telsasoft.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Erik Rijkers <er@xs4all.nl>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Zhihong Yu <zyu@yugabyte.com>
Re: support for MERGE Japin Li <japinli@hotmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Robert Haas <robertmhaas@gmail.com>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE David Steele <david@pgmasters.net>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE David Steele <david@pgmasters.net>
Re: support for MERGE Bruce Momjian <bruce@momjian.us>
Re: support for MERGE Magnus Hagander <magnus@hagander.net>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Magnus Hagander <magnus@hagander.net>
Re: support for MERGE Daniel Gustafsson <daniel@yesql.se>
Re: support for MERGE Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: support for MERGE Daniel Gustafsson <daniel@yesql.se>
On 2022-Jan-21, Japin Li wrote: > + /* > + * NOT MATCHED actions can't see target relation, but they can see > + * source relation. > + */ > + Assert(mergeWhenClause->commandType == CMD_INSERT || > + mergeWhenClause->commandType == CMD_DELETE || > + mergeWhenClause->commandType == CMD_NOTHING); > + setNamespaceVisibilityForRTE(pstate->p_namespace, > + targetRelRTE, false, false); > + setNamespaceVisibilityForRTE(pstate->p_namespace, > + sourceRelRTE, true, true); > > Should we remove the CMD_DELETE from Assert(), since it will not happened > according to MERGE syntax? Absolutely --- silly copy&paste mistake. Pushed fix. -- Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/ "Ni aún el genio muy grande llegaría muy lejos si tuviera que sacarlo todo de su propio interior" (Goethe)
В списке pgsql-hackers по дате отправления