Date: Thu, 12 Jul 2018 16:59:09 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Amit Kapila <akapila@postgresql.org>
Cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Allow using the updated tuple while moving it to a
 different par
Message-ID: <20180712075909.GG7352@paquier.xyz>
References: <E1fdW6s-00054K-QA@gemulon.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="G3juXO9GfR42w+sw"
Content-Disposition: inline
In-Reply-To: <E1fdW6s-00054K-QA@gemulon.postgresql.org>
Precedence: bulk


--G3juXO9GfR42w+sw
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Jul 12, 2018 at 07:33:54AM +0000, Amit Kapila wrote:
> Allow using the updated tuple while moving it to a different partition.
>=20
> An update that causes the tuple to be moved to a different partition was
> missing out on re-constructing the to-be-updated tuple, based on the late=
st
> tuple in the update chain.  Instead, it's simply deleting the latest tuple
> and inserting a new tuple in the new partition based on the old tuple.
> Commit 2f17844104 didn't consider this case, so some of the updates were
> getting lost.
>=20
> In passing, change the argument order for output parameter in ExecDelete
> and add some commentary about it.

Looks unrelated, but flaviventris (a snake?) has just complained:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dflaviventris&dt=
=3D2018-07-12%2007%3A36%3A01
--
Michael

--G3juXO9GfR42w+sw
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAltHCk0ACgkQnvQgOdby
QH2YkQ/+O5zUXwuLhmXcyej/hNQha+B8ejrMkHKGvEHcX0ISKCPUDZQdQ4TuEZkv
49nq3c+Jghx7QrGAyV2179ISEEuQyUzs+19iLhYZm3O0sPtnw8i49EZwvZIKWeFz
4TiwQt70YMrOcmRG5HmzXdXmpcQqRKX9fucQ1ddPH7kmEgxMHf3+hpaOMzlsYaOh
nNMNTQlWAslDHMKfOt73JKn+KxSUSVPYSYPOzqVvNIDfqv4IzMQmSjDkun2bll3v
qpmRV7YUNh80xkuffXWOuvpJV/ipwmGpA9EEUxkF4P5hOKdlYj9Vrzjmrg5omJAT
POiuqCBX8ZR1N5PMwVU4b3EM0pFxiS76D3pAstO/XHwzhknCbIm99xc2PsdcGmkk
kGwSywK/b6uVTGX7zkToSd8sukAxNYHtS+ygY7vte5e4BhWE5TRWLaGqUUFgN0+U
nbeyVhRvPrdY6yO2ZoTqnvkKDlHlvONDslA19ow4XYcvSEU7TxnPkhkWksEQpeq/
BK8tOOzPeusgxujKobwnOAXFUx5aRnmqilKYEDOJS/TG3etW52ZSNXMbuL5Pkht/
1TF3L+/ViGAaINQ7dRXdfZIqBbL9dj0mrcGaTacmro3dIfYDqawqQ6t0iputuNlA
5K7NzlfHEASvNK1cDms7tc8ZWu6riY2a7GvYJCDt1Emsdq4OYwo=
=qa7H
-----END PGP SIGNATURE-----

--G3juXO9GfR42w+sw--