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 1wCCh4-001l7R-1x for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 08:30:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wCCh2-005bBd-1m for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 08:30:53 +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.96) (envelope-from ) id 1wCCh2-005bBV-0p for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 08:30:53 +0000 Received: from mail-ot1-x332.google.com ([2607:f8b0:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wCCh1-00000000lak-0t3y for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 08:30:52 +0000 Received: by mail-ot1-x332.google.com with SMTP id 46e09a7af769-7dbcd92eda5so3073013a34.2 for ; Mon, 13 Apr 2026 01:30:51 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776069051; cv=none; d=google.com; s=arc-20240605; b=CB6LgS2Z7iKUx9TdtYTS2N+bMBjBUDfRx72Ud/cO0kYnsVFrKfGUumb6PMfp0b76pZ cDCBF9MTXbVOTzPb7YmL5x2I3Rsg9MjASOEivcyNKG/vZMp5vHntXpSfvyoobBcjgjqV gOJrzBbARMt2QGsIkhw/oDjpdW4aNLwX8Y98a+C7J33bJIqemj0kT8tqlsSmlTpg8cTC IcVNbuHlG2gxB0sNI4qWCC7qf825OSX+Elv/kshG/f9Ky2mk59kTquZjecsoBXOdcfD1 VfOEAtO+jodshv7UhxG4PgXkfeo8l+AHLQdLyC5BmRogE9Mc+0aLlBI10nMEGVwfhgR0 PFUA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=M5LfYEkL+JCrLaeuNCThlQ10uu6I4VXTc17jtcVFU5I=; fh=00IWzWPFDQQuctaejTrtsWX6i3OxUj5vEfxEYmzFTpw=; b=cFjxqgHZhEjiWofBhLJP1ttFXMZyI1KS/ImjRcx9fbzSQIWOdEp7PKgd2ypAz1HM/Z PYzzGLftgA7O57mADlyVQfaH+1QbuulzF/UpjKT80E3ChbYJCz+Yuwbc2UG2f11YqbwC SXrD2mYtfAIL82IhULgdDXAeRJKpore37he2rJyB5fMifY7WyH6/8SPi21ccqi5dMcLl lTQkfnuuO1YuCco3b0QSz/Vuif6atmtdRJvx1kV4pS2YtckPsME5NbRDoDQxN9/uszLl jIwp7yFCSzHyHHRESlgdBNC2acMQu1kf0qy94aiEbjK1+dF5pTIm3c2Nf/+tvrtvK8lb PxKg==; darn=lists.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=1776069051; x=1776673851; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=M5LfYEkL+JCrLaeuNCThlQ10uu6I4VXTc17jtcVFU5I=; b=mvo1Jy3y+erjyObsZehskJYggq+/3EoAf2UZafat6KkTD5+qEK5ZY8cMDFaL+c7Dqf xXgIElxy/dhCBGPEMLvVsg/lT8zcoj8V/sr6dQ+9HRRaO+/7l47LRCCij1bYlNknVa6u ESEPGKckwM8CJFne7CyXQIwvd5AFr+J8AGtJF6fKKZeqdXoUU9Qfnq7axFCL8xejMk8+ CiPKIav4FWOxUCUnoaJn8h6mSjw7FHQ3S8vMYe8Sk7BEHEfbAgbZPV25hajgZizMRx7S BSYeAkkL4o4tu1n/McI8ngyCdLdDEuwis5sxf3Q/uiXU8IJq5S6Xkq/Y4LKWCMNA+1S+ NOSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776069051; x=1776673851; h=content-transfer-encoding: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=M5LfYEkL+JCrLaeuNCThlQ10uu6I4VXTc17jtcVFU5I=; b=EIEDGRw8msMcu8qGKqv4wORGbY5m2f3XWpHmYoneZyvyePoSiEklaUrgQN+UdXdp9d 5LUAZVOi7eErtOPEzd390HR0deYvnA8D/BgVDlIeP4q9fYBhy5/q828yH806MiXc7+AB 2aWumYcEMDs57XeaspuyUjwzbN5J7dCtbkC/wJ2AGRPeRo7NllG8xWPZcAtaovuFotSS aOdYbv/r5uoihGg1FBUcvmCVOz0ERA8ek23EjNTFmS47OGXTbbzMO+kBgbby3+XNjWoi vk5pwiaDUnEuzAsUsUnYuujHvdrc/w4Kq1wz6nnovk0l5YLjXWBPOmcwBBuSExU3RLFL 4WYg== X-Forwarded-Encrypted: i=1; AJvYcCWGOAKV4TVQobKqVnWXji6Xr1REMzVdtdYlBolkzBuRpD8DkItIe7G3NLfdIE9zl+HOrfIdGa8xWoXcgbNb@lists.postgresql.org X-Gm-Message-State: AOJu0YwDWy8X2HCeKGZiuke+eD4CIYcPs/M2IOQSaNcwaAmxVNOMBR4g 6pa5OK8rtP0eJjyzfhDn8rWahT9pKp7yBoz/V1EdfalhZZYQuVaNR4WEbmHnowxgZ/7vAcqUxm+ DeZfzhC9k79u9aZrlP1AAJzOz69Hx1YU= X-Gm-Gg: AeBDievMxOJEwbCQ+E+N4a0qs6e3r1mVXBqiNASXugb6a4np+rnLTGZLhElk6rphzmt RFdxcqWUdECBMn2RLZuaAO3ZM1NEuLxhsTo5VfoAaxU7Y+wqwwr5ii8COZd2RUL5moOQBDco6f9 szsJ5NiL1hbeSjGESueqnP0mowSpnlJM9EklogPxueQIkF0gKMOEucGowxpqCLKvsrYyv3IPc5m pwoCnIPLAJa6xrN6HPah/LfwSBraZ6g/PnrIDEDta2EHvG6FSoP2Jx8jnP4KXPKg0ldjX24iFyV IJC9P2R4 X-Received: by 2002:a05:6820:f06:b0:68b:6c1d:225f with SMTP id 006d021491bc7-68be6238f99mr5743990eaf.15.1776069050840; Mon, 13 Apr 2026 01:30:50 -0700 (PDT) MIME-Version: 1.0 References: <22B4A33A-99F3-46F5-BE0C-426A9E1D9ABA@gmail.com> In-Reply-To: From: Richard Guo Date: Mon, 13 Apr 2026 17:30:39 +0900 X-Gm-Features: AQROBzCWLyQ1Cu4fKVlBkwgV6yYn1EiK4L4o_mlktdU45qfIq7LlJJ44tE1dCZY Message-ID: Subject: Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) To: SATYANARAYANA NARLAPURAM Cc: Chao Li , PostgreSQL Hackers , Peter Eisentraut Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Apr 13, 2026 at 4:27=E2=80=AFPM SATYANARAYANA NARLAPURAM wrote: > On Mon, Apr 13, 2026 at 12:21=E2=80=AFAM Chao Li = wrote: >> Do either of you plan to propose a patch for this? If so, please go ahea= d and I can review it. Otherwise, I can propose a patch in a couple of days= . > I have a patch with me, let me post it shortly. Please feel free to share your patches. I've been looking into this as well, but I'd be happy to see independent takes on it. - Richard