Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rUjGs-00ChpZ-P9 for pgsql-bugs@arkaria.postgresql.org; Tue, 30 Jan 2024 08:15:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rUjGr-003eSX-T5 for pgsql-bugs@arkaria.postgresql.org; Tue, 30 Jan 2024 08:15:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rUjGr-003eSP-Kv for pgsql-bugs@lists.postgresql.org; Tue, 30 Jan 2024 08:15:05 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rUjGp-00477U-AA for pgsql-bugs@lists.postgresql.org; Tue, 30 Jan 2024 08:15:04 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id D32B33200B8D; Tue, 30 Jan 2024 03:15:01 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Tue, 30 Jan 2024 03:15:02 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1706602501; x=1706688901; bh=dghscJy21p cVKyJ4AE46YLOI+bUhQn2QHP34Ds2axEE=; b=xHdhg9OQTUFbOWx/wVtKnI611z O6QeOBZb77lTjreMVqm6pAojQJG1K5l6ep56Yrh9GA2yqwIZurqf8QqpmmPj9vCa GCuPjsQOSVW1rEHDYfLXDmKDFr6fmU0psLCLqRxnZS2l7j5+5Yb2R98MuQZNCuVx XbdkipGHnmTB5fuMFbKUvNx7BQ71WzLMQnOTxj2Rx6ayNymj6ZcsjGMifML4n1Yo G/j7/TYcAz4dD9IyFadddrN8f1rWkdt4uBIgmRn+qV4qykJLp402kV1pgx2aJhWM 1uJUcXcoX17cGfk4KHM17gIuIC0VVetLAnoMF3vcklymY3JAI7w0STLPGCrQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; t=1706602501; x=1706688901; bh=dghscJy21pcVKyJ4AE46YLOI+bUh Qn2QHP34Ds2axEE=; b=nwyQypavVW61zRzccDiimMkunwJ9+isbBbaMaE/PTMJ2 j1SBFkZaWz2um6J0AJSLmTwRCyIlPJTjxmCl/CZvJH+2o9lJNIm3H0XPh72u2DEe KExLWkhuuNVFcwgLWg+tvf0eSlbQMH7bEKwQ/A2I45Zr2lj1qYvUeZDWSydLd2ui 4WoiEOUjrz0J0hRptjyBdwVOvvgXpForMEIoooyoJU1fJPCBETWj5QxkjrC8wz4a /R9SNqcjitXWzaPsQMu7hIbhjLnBqcztNpRoqzZLC5J4YqwAujeMwyrsm/Jr3Bwb 3w+5UZx3m4rbh6nwHcNTmdRwyy7cVpn3y33FhniN/Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrfedthedgudduhecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enfghrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreer tddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlse hprghquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteel geeggeffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdig hiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 30 Jan 2024 03:14:59 -0500 (EST) Date: Tue, 30 Jan 2024 17:14:55 +0900 From: Michael Paquier To: Tender Wang Cc: Alexander Lakhin , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18310: Some SQL commands fail to process duplicate objects with error: tuple already updated by self Message-ID: References: <18310-1eb233c5908189c8@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="7iQXidJ4lPM4630C" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --7iQXidJ4lPM4630C Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Jan 30, 2024 at 04:02:06PM +0800, Tender Wang wrote: > Thanks a lot. I want to give it a second try. I will send a patch based on > your suggestion. Sure, feel free. -- Michael --7iQXidJ4lPM4630C Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmW4r/8ACgkQnvQgOdby QH1byA//XY5S86AFILzGjQoOJ5PCpZc7rREgoeYhypPczip1MQccSBcK6k2H5UnL EgJEHbhu2jiYsp8LtV1HEVqQPKvWLzvj7WlNGq3ANWPearj0MGEZGA8Bq5Q/Je96 YQjuiakxCLo22UqykAaumnKMWj2BSfuPg6ey0qzZEIln3UsGNAiUbhp0gOe42rNO oC8VylKwcps2IVCIvWzTjCSUb+ck7FY3o3DpIo88UKSGmTUXzEKAx/8iC2KYH1Re N/UL/eMOF4YePpN20yASbp12JMtnWffG+geRyIGXr422o4JkNsOfqUdrlEDeYNxk QQoK8gyH2ZM7sLc2i4Rw8svaW4iW9gNpzOAqEqgYB90SRyQVFbRv7GxztLa9Lfb+ KX9hFcWDmjLuUD14CQpF6+J3udD7O+Mntl74pOFSYNOL/PeixlJdVnqb0oGEK4z7 ycLVpTxax7EY++KCIf+eAIsHS+IKBnGqHdOpgAmYxrLq+pz1jrCS7w096uzne1mi W67d0bSpVVZt2SfUQNFn5JlxdzRLz6nR4EmneNDV2EzafiMyM8Te7jG8KS0LuM1H JcMOrAD0iH2UHoCkxdM4JX1dO/OlWP6IkilVHhTX9tRR/2EwAsvS7XvSBpCMtVBm 1nccxlSzSQA6rw/iWsQOWn2BX8GPaYrwQBFRLSPPbVG4jU721V8= =SPEf -----END PGP SIGNATURE----- --7iQXidJ4lPM4630C--