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.96) (envelope-from ) id 1wxNVu-002g7Y-2z for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Aug 2026 11:34:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wxNVt-00D5vX-2w for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Aug 2026 11:34:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wxNVt-00D5vO-1I for pgsql-bugs@lists.postgresql.org; Fri, 21 Aug 2026 11:34:21 +0000 Received: from fhigh-a7-smtp.messagingengine.com ([103.168.172.158]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wxNVq-00000000UgF-2XdE for pgsql-bugs@lists.postgresql.org; Fri, 21 Aug 2026 11:34:21 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id B5E1A14000CF; Fri, 21 Aug 2026 07:34:15 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Fri, 21 Aug 2026 07:34:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm2; t=1787312055; x= 1787398455; bh=KPknfvRk898PSF7XXJNqulblQOZdiwJHlhDcnM5MxWE=; b=K q8EjwqShmqMj4Lh6YlGVmyPqvNQd+ATkX25A5sOFKmS3nm+ftaYDNCWGUunFc4Od jtR6n+QLyFy8lzD+jdQKNxg1ZCVpd0l6hzcFGee+jG6Do79yrIyMGzJKjW7FQ2vl kUGr9X7NykXvFdYcTDiIrJ5ceIGV3pjN+YN4e3tcxCr08VKRyFBmZjRIAnqac8Wr ePmGMkGlLu6a7UeiivN8tCBtsxAbLljtzmujPezUX7pHALWubgLvhB/IQed7mBb0 MiSI/ow8+gk+7xmk+wQdIXlxvO4vv5lSyT+WscaUr0AhWWej1fNnd83jWKx67zIK A3PrrFZM96Uzpz4VT3G0g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to :subject:subject:to:to:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1787312055; x=1787398455; bh=KPknfvRk898PS F7XXJNqulblQOZdiwJHlhDcnM5MxWE=; b=P3AY39+i2AMOJwYkAzzTzb0dFfF6s FeKKaNZbhnfLke/c6sJkA9lTxJ3oZpKIPDNwg4s6dbb0DQWlDtD9rqSbWtkbA+94 s5oxDE/uCb8A3HX/XtFIqUddfRSlZbxsGz7s8vWWjYj3iew6dBDSR0NObobdkpSK 9LKfassvaavT+upYAQhBMjsymgH8NVaK5+/bQl7fUp/A0kvLLFCmZkhHcMgNefCD 7Ify2lupsj4w0lrii6FiihVnnOSzg1ancos5d1i29b19pvEZnIY9p1d9lyWUxs3f 5HsiwqhgSCZ3O279X98h2HsRhpSmzTKPrz61FQMgS9YL+F5I/dcqsuEFA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFV54WL34zlVH1HpIVyr9Mf68OZdtf3pWbaAUnfR86K0ZMq0uX0+QDYCLKSogg7ug +11b2BkvoPCfwB0IM+RpoxMh8b4kISSuQSElYVQ2psTetEl3qp2z1OEgg4RgJB7N9amTMb gHFVushkyribW2n5omQdryTOkgTagRElUGOOsBO8Z8MuwgMlNf0N+VePTmPw262qnu8km8 mn15CPLSCQ0t36ahkGtaiVGw92z1WOCui83ihS0P0NJ1TCorI/mGed0s6MiMN5TKLuHD5H 1ujLVJvcKtDZddpsCklgttsg6z4e3jGhkqdTVk8BXk4jPv1r5PMhFm9YEiytEB4sMDk+qw ihLXhyObk8Aqt9DIOXgZ9NvOxVDDxEh/iiuxsfAT4m0CbCwdBEDhGEWLqLWehvqgCxIXLz qXmPwKI1u56Tykk9rlYtdcBh9TAJRXRUlFd+4QU/OSXLPHsDK6e9xEYwX0QudpMFVN2Ne4 3Mfg4TKv7DYwLIz+jKUB7CARU3tCan4qVzf4z//rDXE2bPac6GvnSnGswB8DYoOc2xvRFF qI5Iq4onpJK0WnKrDyxLLkfAFZYyiJg4w2H1tCT92c2x6EaUASKBWdiveD43pmNHM8IzuV zVzRwbtW+olCCBaNElvAsHCg6vbz0xUVXjQ9qEh8Ck/TSoyrAGhN/Wr4jROA X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 21 Aug 2026 07:34:15 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1787312051; bh=gcX/uoWvFOn3oTPCUpY/GsLsIy5DIRKcKSW4BZ9jr9M=; h=Date:From:To:Subject:In-Reply-To:From; b=zqrg3dtmlDgrg+WSsSzF8H5J1LgB5MEvparRB6RwKydadqtZrcDtQVqpCgco8XbD7 Aue9onWgEJ5GTFnOau1hoX2wriD3b+vioBFK7PQR7INCbfAtHEI/Qzb3uZCFU2eAuI EcZgM+KaZVwmyMdr5k9n9BpLgE7TF9pDSmGy47P/OkfHj3GRSsDp6rT1kvo1eWlZ4c s8RE/xvnrMC2GcIchbuEu1TVAfZMW6nbExeQzH25mG6AQ8Fd7aPH2I6AV3Em79d2dq iTQfc9ikxGZrlQRQxAeSzrDXzLlBjZPzOSHuMyTum3Rj7GTrUV7g0Ktpropnj9kt/5 ZARcunridCn0A== Received: by ida.kurilemu.internal (Postfix, from userid 1000) id A8E1EB001BA; Fri, 21 Aug 2026 13:34:11 +0200 (CEST) Date: Fri, 21 Aug 2026 13:34:11 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: hackerzheng666@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19632: RULE rewriting crashes with XX000 when RETURNING old/new references a system column Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <19632-9155d9baec763c8c@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-Aug-19, PG Bug reporting form wrote: > Reproducer: > > CREATE TABLE t (a int); > INSERT INTO t VALUES (1); > CREATE RULE t_del AS ON DELETE TO t > DO INSTEAD UPDATE t SET a = -1 WHERE a = OLD.a RETURNING *; > > -- All of these crash with XX000: > DELETE FROM t WHERE a = 1 RETURNING old.tableoid; > -- ERROR: XX000: could not find replacement targetlist entry for attno -6 This is not a "crash". The server is still running, no process has been restarted, so what you see here is an ordinary error with no further interesting symptoms. This report is a bit alarmist. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/