From: Justin Pryzby <pryzby@telsasoft.com>
To: Álvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: Amit Langote <amitlangote09@gmail.com>
Cc: Japin Li <japinli@hotmail.com>
Cc: Zhihong Yu <zyu@yugabyte.com>
Cc: Simon Riggs <simon.riggs@enterprisedb.com>
Cc: pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: Daniel Westermann <dwe@dbi-services.com>
Cc: Erik Rijkers <er@xs4all.nl>
Cc: Jaime Casanova <jcasanov@systemguards.com.ec>
Cc: Andres Freund <andres@anarazel.de>
Subject: Re: support for MERGE
Date: Mon, 1 Aug 2022 09:52:57 -0500
Message-ID: <20220801145257.GA15006@telsasoft.com> (raw)
In-Reply-To: <e0d96c29-6211-48bb-be50-77af87dbbf76@www.fastmail.com>
References: <202206011528.j2i6c64v7yqs@alvherre.pgsql>
<e0d96c29-6211-48bb-be50-77af87dbbf76@www.fastmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-hackers@postgresql.org
Cc: pryzby@telsasoft.com, alvherre@alvh.no-ip.org, peter.eisentraut@enterprisedb.com, amitlangote09@gmail.com, japinli@hotmail.com, zyu@yugabyte.com, simon.riggs@enterprisedb.com, tomas.vondra@enterprisedb.com, dwe@dbi-services.com, er@xs4all.nl, jcasanov@systemguards.com.ec, andres@anarazel.de
Subject: Re: support for MERGE
In-Reply-To: <20220801145257.GA15006@telsasoft.com>
References: <202206011528.j2i6c64v7yqs@alvherre.pgsql> <e0d96c29-6211-48bb-be50-77af87dbbf76@www.fastmail.com> <20220801145257.GA15006@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox