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 1wC79i-001fyi-2t for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 02:36:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wC79h-004C4a-0U for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 02:36:06 +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 1wC79g-004C4R-2n for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 02:36:05 +0000 Received: from mail-oo1-xc33.google.com ([2607:f8b0:4864:20::c33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wC79f-00000000jAT-2lvo for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 02:36:04 +0000 Received: by mail-oo1-xc33.google.com with SMTP id 006d021491bc7-679b072ed3aso1731503eaf.1 for ; Sun, 12 Apr 2026 19:36:04 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776047763; cv=none; d=google.com; s=arc-20240605; b=TMT6C6NZvhj5IYDoBsL3qFSX7KMhtsCVdTCx7y2FsDOczAynXASAb4CqpBC/ZDrz66 jh1F2/zwRdMiFOP0mM7APEKCHI0q57p8J7eSF5EJE43zeT8lvDYgn3UjqHzLOCUl8Yr0 6GhH0qEQL/fQBV0yeO1zTMihhw07GrYaLayDZHm1cDoM5+7D6x/Q15nRcUTnRE8qO5D3 YB3/8dqo+Rjh3xCXGXd1bmsUK57IIaefi4NrN9wtxQikOqvtgT5LJ8xBKrJx1mCcLMvo CPvOqGKtJNGCx+lhltX8ibIwyzge50/T4jlNTvgOoJh0FL9n+M9q2mJQ8adwsABbQ3Hx kuow== 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=UYDBjiEDIOQpugSzzCasyR+hC24F6YCXwoKFluslUyY=; fh=oVNqw9CRHYoenHXm+qMD6XfHmZCKdpC41i6FwsKLsNA=; b=aqm7f/z9k7Zsi2vlr6AOQJhwE+zA9FatOcHx57GslyzdohYHyDg0jTdbbow4eI7uFL hVexjBhdXGZfceeLIZeyJaw6WVTVItJEgQvv2N4ITd4h4clCGV950GeJl4qgWjfnC2ov z/xPJkdxK3reZ6iPxp/g9XmTRVAIImD8oURjT5rP34zh0TAaqxxrf+c6kyYeGPj037GF EMdT1bkPmGLWxEebKtRi4iq4BAOfkjyo/BwhbdV61Xo+YuV2dUC4HFlVBD5aITnVbCL5 dix+X4OzRJ6+6+3rq3QRPNoUZ4e7PrU5+om85+fFZotIA34c+jSpGwIrpAgM5nu5hmWV eZGA==; 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=1776047763; x=1776652563; 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=UYDBjiEDIOQpugSzzCasyR+hC24F6YCXwoKFluslUyY=; b=mgvWMtkLkigMjY06lbUGf4jnX6OoDfM3TLHxvqzOfr+LbI8esQ44A5YEAfIupKKxDu K3sLE+6VGWgRTI/Bl09aXnDY1DNjYnHgstD4ZzrmMueRs07uJg9eZanCz/lbtndmJRnF Ld1zBLOZf5AoRljk9f8U28UhgtPPlDml8IrrnK9n2v1yw8oN15xf8qZYGFgaBpSGF1Px 3D8KqmRgVcu2mgVDmvaP1gQCZwvwVlNMK5cvs8h7V55vZPhy7FO6By0dsLGppyLnufa8 wI5GK5MJxkikz30722HLrB4KYxtMW4SERJG3Z4/RSN+9KEBDvU6o+mPeL7+ltpbOzP7U lAwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776047763; x=1776652563; 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=UYDBjiEDIOQpugSzzCasyR+hC24F6YCXwoKFluslUyY=; b=KUuwU1AIgrbYlWR2sPugqiOgUogQXPYRegthMKumPyPagBfv6WkV66MZxCo1l5nmeB UINEwQZgIQ6hEoYkcJCR/IFQ/27FOHA3OlbfuPnPLHpVGCNzff6AQs+0eSqpvAzNibDQ E0yFwrplAMJ1+4yIaDfBHKjKdmwiq3G1Ys3RTEt9gv4ZyioMKheGfdLC3ddfX/e+xa+n x8Zv0cDu++paf1T1Oy1wq45nrO5t6j63QYJEShZv+41TLO7q2GvPmL5tXYVA/Ca0FqQ6 ezw9KrZuqU3doZeTRYSlyvpKypUnjmyqnZVE1eo9oaUT6xwz8kQ1IEtAi1c/eCFg8QR0 g4IA== X-Gm-Message-State: AOJu0YwdQ++BFf5422cS3LwLPF40tPV2hO4eojmTWOK2RobV0z0MjUcl YE5FDwNp18lzhxWvg5TRtOn6kYV46SKpMiPPxuXZFSol1C0lGdSXtOhhw/ywW82YM9h4WmfJ58/ BxVvl7/j7hhTtZkbWmt/lBtPeU+MxX6Y7z8gccB0= X-Gm-Gg: AeBDiesyPh7EcjzOCcbjZ0kDLpWUrCPiZ6ptbLws1xGwNJWPpKtZElDgrbKiLWPtq5k Et/j3ISoqVjHiGRtNEIX7tkMZEsV4Wv0OWqfypVJiQtJyEVLxOYEkvFle+RM0x0jTtQ6h0cUNDC aJL1EdTfAp3W8PB/GZeHwCalDArImIYYU3wFowwUVyg2noN7Gkr5y9fFxmjtDyIMJpo5+xIizvu /1zg6g2d3GIUTd0toEgVK1gCXqUu2RSB/F+SCA+NeWYl3ZJqP0zQKd8i8AoAGLHApML4vmWelRN qgM8wQom X-Received: by 2002:a05:6820:818f:b0:683:84f8:c0f0 with SMTP id 006d021491bc7-68be7ee671amr6240912eaf.36.1776047763468; Sun, 12 Apr 2026 19:36:03 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Richard Guo Date: Mon, 13 Apr 2026 11:35:52 +0900 X-Gm-Features: AQROBzBvbO-JujNpgK5rjkcUgqUBiFTliP9zfMgqY1sQJSmvPjxMa4flI3qmtJ8 Message-ID: Subject: Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) To: SATYANARAYANA NARLAPURAM Cc: 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 10:59=E2=80=AFAM SATYANARAYANA NARLAPURAM wrote: > NEW. is resolved to the OLD row's value > for update or NULL for insert cases in a DO ALSO rule action for > generated columns. This bug affects both stored and virtual > generated columns. Reporting here to see if this is a known issue > with generated columns. I didn't find related item in open items. This does not seem to be a known issue. I think we should fix it anyway. cc-ing Peter. - Richard