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 1wF4Ee-004iKS-2W for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Apr 2026 06:05:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wF4Ec-006cIh-2k for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Apr 2026 06:05:22 +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 1wF4Ec-006cIY-1i for pgsql-hackers@lists.postgresql.org; Tue, 21 Apr 2026 06:05:22 +0000 Received: from mail-oi1-x236.google.com ([2607:f8b0:4864:20::236]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wF4Ea-00000002FeG-1kWW for pgsql-hackers@lists.postgresql.org; Tue, 21 Apr 2026 06:05:22 +0000 Received: by mail-oi1-x236.google.com with SMTP id 5614622812f47-479d68a9063so505954b6e.0 for ; Mon, 20 Apr 2026 23:05:19 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776751518; cv=none; d=google.com; s=arc-20240605; b=NMaySRdDuPpeWJ/LGZFXXl6oj/ouM3bc/Yq66jzQOZnF+bDAHk8xbFe6AI7f8J8OPo tBF2wDt8Y9djkHU8XomUgoCYmLB66JGFodGig0BOwzfR38zTzH8jeNMINPbQGYHCtxKT hmMwSfyRqbgG+fgZeZx0r6+6M9B8tSJi4M4CzaHrhWh294EtSg69cnUZ+//PGggtSIS+ EwQ/aN5QCSKXxKQytIm+E4MNHwwoQBxYXcOtmbj5UxaExgBlCX8k1JMxFg3c/i8THsEz 6dmfZeMMged0MdfOUJOujHe27Ehe2zPs2WzcSb3wPOyW6NvuV4kXFHocuPoKm1K959PO A40w== 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=/DYI7X7TCeSeGKFg3NNHtTT6qemSw6WPOfesipqYpmc=; fh=bg9J19qWg2PtQ6YoehtR0RHWpIH360t+6BMT9+CbhOw=; b=ZrIg4PDInJFizv418NJ1M6PMgPU/6sLN/GlEOiW10H3P4qaQbz8sQzYzEHLJWk5ZOK irvpL9h5pH0N2e9JpqAa5RxBsagmZSWGcrZsnVWIgZf6HmMtTv3cL7mr+9vbgnrBQkQz EM+/X157M95aVoEtVv4ay3OTBHLjs/GKUY1xcgIOZrgMvWf2aJcfOfhvmRLoomHVtGTC 89zhAoLg2D1fpS70TngkFJtE6VgZJWkjZ+OBXCmLSMibKsG2yLJ6iJbeMqXAnktBLRzv iuljHCW+CuHRImKsCwZFf/RiHcTraRD5fMso2xdXbk+lnmcBBxA+nhhZ/5kadGksqck3 UrdA==; 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=1776751518; x=1777356318; 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=/DYI7X7TCeSeGKFg3NNHtTT6qemSw6WPOfesipqYpmc=; b=NhmNIRIsrk7K/qCGqBXbId1UAXjfLjdWA4L82w+6ID9FemKYnQlQkcWvgMz9UaoQyI OLHnxo9XOf717PZgfiwTssx+W3U+zz2br6sfXfabIpE1Ai67sVzvnUn4mSJ3rbgan9mJ pC539o7IyZbN6p4tXodWfQvFH02ptOoNpuDRs6OglP6Dt8zpXQ4RV0DfTF94aaWgiCKr fhUgYzMJSpajK62uClw2iRX0OuUW4chuaSbZdxpnvseRaekSlXCyTe8hDukewc6JNGir RWFEjnc37U13hlY/60ktjUuVDU3siihESssPLdy+XMudngicTKxTfhmALpunfF2Lra0Y kVaw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776751518; x=1777356318; 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=/DYI7X7TCeSeGKFg3NNHtTT6qemSw6WPOfesipqYpmc=; b=AI3b25GtvIIAONCAeLosUVJIK8VktACWRduWBpHr4yRmfT/mgR4+2J5pl4VMyZQyN9 BffFg4LDksLojZAMZNpw8jxcT1WHOzQgI5sFSDfXFBWMep4vK03j4vnDJvyaZBM1Aswl 6v7Oa5cAYZtyJ7A/b23oSKE5YQaFckg9ROC6jJS76tKzn3jJIHe3CHkz1eyhDssOFjp5 cCqc+i87flRAngr3Vzwzjrdx6vjF9r2u9s1LhO3EVbOw4BtW50aZXZRbOUiK/kbDafih KVCQzkE2E77W9szACQHSvtBQ6bvJAmdvo5AdnJHEamCCj1GkUSvtvkSPqUwc+jwgbLIz aCjQ== X-Forwarded-Encrypted: i=1; AFNElJ8pp+PF00vnAJEXqR7sRdhTnewI67nFgai0mc8CXE+CM3Eq0JyBT15r5EfCqmMzxiwA8QkpoVk7I9fFKUl5@lists.postgresql.org X-Gm-Message-State: AOJu0Yyl/EQ+1kkiUriJ7ju+vhHn1ZFw835dvA9pUVYK1NJFrXgLuNY7 4HfgmnkIAD/J4O5lGLESHd1X4guDGA+R9WGi6Wxcl9Qs/jQM/3WeeSto23Q/3YBcgQcqhfaMbXT gozeUrsOTz2/DKyvYnS+DNM+U93i4Bec= X-Gm-Gg: AeBDiesf/V+wkb4vCLdMCPdCsD6ppJK1DzXukUB7Db2ExOo/+Jwt1gQkhsfyh7RFs1H cDyzaKFwf7mWq9rXA25RUOlGokGeMndsFIKz715r5uEBTW6xs7MdVUx5MskZoQ8QRa2ZPAIAiAQ IqCzN8VrglyZD76TQZNRi71eKe9vn4AseIs5i4Qmn8ge2vzN6HqUYKJi2T/eZl/Yc1mY542T0P3 XgmcM8XDUDQJtYlLIYmM++nzAFpSBV2q6NRdMSmKdgoT0WFGVZ3SOFvY9I4vsf60xJ0fDnyGxKF hbrLecs5nLRrzcLOBZ8= X-Received: by 2002:a05:6808:6f8f:b0:464:5f3:ed1 with SMTP id 5614622812f47-4799ca04e4fmr8941845b6e.26.1776751518311; Mon, 20 Apr 2026 23:05:18 -0700 (PDT) MIME-Version: 1.0 References: <22B4A33A-99F3-46F5-BE0C-426A9E1D9ABA@gmail.com> <8D1CD3EB-BF72-4C73-AF24-D88581AC01BE@gmail.com> In-Reply-To: From: Richard Guo Date: Tue, 21 Apr 2026 15:05:07 +0900 X-Gm-Features: AQROBzAjgv_vRXPlPQzDYR1qqn8Y4J-L5dP8wGkXHRSMwW6Csg-RfEFf8Fy-ieY Message-ID: Subject: Re: Bug: Rule actions see wrong values for generated columns (NEW.gen reads OLD value) To: Dean Rasheed Cc: Chao Li , SATYANARAYANA NARLAPURAM , 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 20, 2026 at 5:42=E2=80=AFPM Dean Rasheed wrote: > On Mon, 20 Apr 2026 at 08:29, Richard Guo wrote: > > Attached v3 fixes them. > LGTM. Thanks! I've pushed and back-patched to v14 (all supported branches). Virtual generated columns and some helper functions such as build_generation_expression were added in v18, so the back-patches in pre-v18 branches differ slightly from the v18+ patches. - Richard