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 1wCIzG-001qyF-15 for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 15:14:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wCIzE-007bdW-22 for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 15:14:05 +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 1wCIzE-007bdO-16 for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 15:14:05 +0000 Received: from mail-dl1-x1236.google.com ([2607:f8b0:4864:20::1236]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wCIzD-00000000rBu-111R for pgsql-hackers@postgresql.org; Mon, 13 Apr 2026 15:14:04 +0000 Received: by mail-dl1-x1236.google.com with SMTP id a92af1059eb24-12c3d30564eso161145c88.1 for ; Mon, 13 Apr 2026 08:14:03 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776093241; cv=none; d=google.com; s=arc-20240605; b=Q+D+40oTCcv8ZV/u83DCkbQh9fuje2N2w9UQkXsDTPvFZHXjxH8ujuKKiTEK7Nrw27 l6S6bdTiQD5gDxSLqPiOM3KlYznts2N0DAodCShg0IcEB7TZ+yzAc08J3eKtr/3SNfts W4h6toeFXD4qO1nAr2nHSfMJdbe1496xzAyIUEUKPeua+ERPI9x03qjVTR4PTV65OV28 sE5I3PneqTjtPbtJRW5PwAeDhTfpsDHyZ+s5178Xci/hTQrGTYvfP55lzMIzknShplOm wiBu5fkCoQaaJ15lhBKCctjEnpfvHqiJ3XBxSdlfz82f+BUf43ST75F6BnsLzwJzZtBI +uUA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=38e5oHf/9g0ZfN8z0jP8DrRVTxUhyiX9PqY7LKMeNaY=; fh=lXsrIfQmoV/vBWgETkjvSmc9ozHP6WKVZmpA6+BSdAA=; b=J3qo76Jw8H7BmEvUC45CDK/t3t9RJlDfvCsC/+LUR/5remcTN02py3rVNFAGqRT95l /yjMrzUWWMiANVo3CPC2Zz1w+uUrjOYQTKNTduBxk2Ud7ARpZNSpD0XOZ2ZGkOeIZfxx J2FzoXKiBF4p79sitG4uksBdjoAMowTkCKu7ewom2n1+p1j0OONqtzURMBjNEjAgG+2d nznpV4L2kz0e/UgiXWVNN2BvXGfpU0yyyozmHRkN93QYVKu45uQyZtJfgVDlHJHCvQhT jnDyjxXbVPLL+j4QMYyCpJtclV7AohlEk0GXlWPG278R8g7Cajd1OyERaNL3pe/VsI36 0Y6w==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776093241; x=1776698041; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=38e5oHf/9g0ZfN8z0jP8DrRVTxUhyiX9PqY7LKMeNaY=; b=TpPHWnnfEWFzP6g6SzC0cxttPtL+12kqsqZVVWIVlH+1APzOtrmgPOo2cxVw3nYIMl HK3p22cZDRb5gMVCynTyGu/jOGeFtOUIuKw5DPRJASUn14iWUvhFivP6nt3VOAWuikT+ fIMUUuyll9Tx5ZIU6xt0j13mci2hKel0jmlgksMZKLCW5uSvCCh4qN3HoKDmy6x770v2 sh7ycTRA2Be20numgFyk7m+GHH9tiKIMrcXuEUJgq0dMiP0EswlpmO+tD7MI3W9R/l/B 1q9GVILQe6ZQOC1rLT2cYig9lf0sw2XakGvh15qt3Ym1WkRA0P/gcxk4NCqcCmyA++/y f+Iw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776093241; x=1776698041; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=38e5oHf/9g0ZfN8z0jP8DrRVTxUhyiX9PqY7LKMeNaY=; b=RmZaxxw6ALXb0EZIhCLuoN1kXn96eHmMh0UytA4Fk0fl4GAd0rklrUCs0zs2RQBlt2 P6DlShEOpDT315rmVPAzUVP4gVXQK35O/pDVBA+YWIMkXEYkF2faJ/7Zc1uYmNQgxzR8 i3owZ9qpDdtZM+z0fPYnjfq2OVtTL99xsJdZIPG0kPtB3sXyPYo+Le0Ns2gDk1iVeOum niC3l68cySAO3olUggQrqS97TV4hO+psfCZ66Z9J1HM6pauYhLtCdXbDGd861E1EiddB y2g7BdwRK7jyMzfgFDGqdR4fhF5Dfl4U+eKqw9ngyANaSOlenkJKyA908T07e3wyEkzP NZHQ== X-Gm-Message-State: AOJu0YzWJr1gB8V+1lE3fvs4S+cB0vDGiFmKJTafm/cXs1QHrUIjMoII bgYEXiqlVHs55qvAxWE0dj9pTFfdZ/VRaAqzpA6X+ff+Mkt0PFqlkU+7TFOPILxWNHhtX2zy8LD 28eP34KufNedEpIbtPnmD0iZv6jSMPw4= X-Gm-Gg: AeBDiet8+aygqY0H7Qn0GUPb8O+4JZqHqZbnCDzGAaHhRN+R0BU73/99HtXRLMPdvvf fK9pVHcCPJTa7QGd51tTlh69N5AQOYIEnL+TT00ftFxk1n8VUBQ8bQc8XOkHDCT7lM20AH4zvZ9 Jb5dwIiTilUfAdsrD/2g+uxk9dNSOdXYh7ditUChdubg0hkj9MSV/haVl4UPkFho7QwUfjkbH+x j3Z4gfGJ7e2WKEKB3EHJzde13S2nBkuNyt4p/Ne5VJDL2BC2C+JRyVEwtbtUg4wviBKOAN9vz5V W8XYuE8qpWpaCyQQFID5aCRvKyWROGuBA1lFpF2EyQ3wp3R3/DrU5kU+boCxiRowfhWVVs2cW/r 6G9cE X-Received: by 2002:a05:7022:321:b0:124:abaa:7ff2 with SMTP id a92af1059eb24-12c34ee91e3mr7456227c88.24.1776093240917; Mon, 13 Apr 2026 08:14:00 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kirill Reshke Date: Mon, 13 Apr 2026 20:13:48 +0500 X-Gm-Features: AQROBzBrA5iDBX1wjDar_OfbgNmJHnx0sAoRNo5wJ5CBhN4vIa6b6w4cVmOBrvg Message-ID: Subject: Re: DELETE/UPDATE FOR PORTION OF with rule system is not working To: jian he Cc: PostgreSQL-development , Paul A Jungwirth , Peter Eisentraut Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 13 Apr 2026 at 20:10, Kirill Reshke wrote: > If yes, why are we > missing ON DELETE TO ... DO INSTEAD INSERT ? Oh sorry... i mean ON UPDATE TO DO INSTEAD UPDATE FROM FOR PORTION OF -- Best regards, Kirill Reshke