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 <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1whYv0-000IY9-1F
	for pgsql-bugs@arkaria.postgresql.org;
	Wed, 08 Jul 2026 20:30:54 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1whYtx-009BY3-1C
	for pgsql-bugs@arkaria.postgresql.org;
	Wed, 08 Jul 2026 20:29:50 +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 <dean.a.rasheed@gmail.com>)
	id 1whYtx-009BXu-0B
	for pgsql-bugs@lists.postgresql.org;
	Wed, 08 Jul 2026 20:29:49 +0000
Received: from mail-qv1-xf31.google.com ([2607:f8b0:4864:20::f31])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <dean.a.rasheed@gmail.com>)
	id 1whYtv-00000000D8d-3dbs
	for pgsql-bugs@lists.postgresql.org;
	Wed, 08 Jul 2026 20:29:48 +0000
Received: by mail-qv1-xf31.google.com with SMTP id
 6a1803df08f44-8ff88549786so3269276d6.3
        for <pgsql-bugs@lists.postgresql.org>;
 Wed, 08 Jul 2026 13:29:47 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; t=1783542587; cv=none;
        d=google.com; s=arc-20260327;
        b=kONlWDizjo4IAcsgGoSPzPDAptZUfnbfr5VIsL3Bycf+t5kQZyJQTcqahgYQhzjD0x
         fsFXdouFN/6oAeFZjTY49IVxUhVTKcAFWiOJ1IRqrEuAtMQDkfhvpMLTYJJsoJm+cMug
         V4euoGKbPTOvamt/Ry3tj8FNkSxNMIF2fl8izcbgmo84tj0LEbnUPe0TXzJyA6bPkW7c
         uItWfv+GJVQr2IYJyoRfsPIUyfr3uwTyV23KQN6OHNp8DOd+jLgDJxIG+47o/CH2bfle
         omAfT1xTlg9VO2NtPZkfDTEA7NPHGcEaTd6pQLTRWMmd63esJqudFyYnZMU743g/TKjg
         tqCQ==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com;
 s=arc-20260327;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:dkim-signature;
        bh=5X8oOcheVBJzVLau5xanRKubaOyd+jCTDmdl/JTz6WM=;
        fh=DIECdbPQIi7trrKuE43DJFgDxeTOjowEu/YQbglrO+w=;
        b=HIHOUQqNa6wFAOrBwkQkF7O15SUYNLJ08DFSWYQi8tDUdWnYpWQ5L1r5Qietmizurw
         wyP3n1b/QhPBwQRcqArgWjLhKZcR8O84iH/7faxb2WJ55Fx6o4tQZDyrwRzzu5qL7Znt
         EiH7mWbDCO3DvK0fGftCdkHnGhTvPnGxDc1nFtvQOx7GAU6gYDAkpUSLo96Ex2q+wDmW
         BsPQknf4cF7A2q7PKq4dOb89igqX8N+6UbO46s/aI9xow70Rli1uAYzSLJOTti+O5xm0
         WOYvBTKBgfgDC2L4iRrAuFQ3bidJebd2W+jEU8MG8xE4sHIpfaxW7guYgBqp0tMGv11J
         tN2g==;
        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=1783542587; x=1784147387;
 darn=lists.postgresql.org;
        h=content-type:cc:to:subject:message-id:date:from:in-reply-to
         :references:mime-version:from:to:cc:subject:date:message-id:reply-to
         :content-type;
        bh=5X8oOcheVBJzVLau5xanRKubaOyd+jCTDmdl/JTz6WM=;
        b=KlRR/7JkWGuGm98MUSpFzpqYjIayym/MG9LknRf4/6pdWt0xW3DORaacF7xDBesy9d
         d4Pka+m6dBJ5eKtNZvWmQlpXmIXVU/gXoZbHIIQpfGrHsOICYB1pnMbKMQnyaDQw7XSG
         Ca8aZlpJaK0zPRLwbPjO4k+a55PHbJ0yU1IdkczHFrR6xji5/vK0Nxuji/y/lsGpb0Ad
         4TrFr6N9x21zSYI+I+pF+Pt2Zqv1rS/E5w3Lp+NAgAXcb4h3kXzmECAgCI3YYN/QQ789
         86RY1nIa2kZmpm6DLZaruRn1hPPA/30u+Bf0BCAVPwG0FkCiOEMLQxzYdgV/Z4Tntx87
         /F0A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1783542587; x=1784147387;
        h=content-type: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:content-type;
        bh=5X8oOcheVBJzVLau5xanRKubaOyd+jCTDmdl/JTz6WM=;
        b=X3Rl++CIRBac3sYGjhYkjfasv1SFFbfO0mrP/5s3iPTKK9KQq8NR69uynuXKoJmhMr
         1ViYIdk3vXYLWOTo1tw1KjutxflqvSTO1QVKxi1VgwxkehzdfZYX+mW68Nv7qsLLwJJr
         3QdSCFzBbPTy8qmXd9MKS6Zsp3iLszUU2Uus+KvGLqogb8qmgNhJ/ZewENk4pQNIT77h
         onURK4qKHPm2iKZQ7ZsWOnaoI+f5VgcZagbLaijAUB0dRjnc8CZ49Yt+calBXjtG1LkL
         mzVKmjoRcx0Y1Ot686yc82tuw+NntvxrmYBLrPMQKgGATPepMpBagqmotZbOvIa3gsJc
         bKlQ==
X-Forwarded-Encrypted: i=1;
 AHgh+RoKmdcr+6j65BBNf4rTBARvMgtjJB5gL7fx1/R95DuYmVnEQbsRRGDXJaPj3pxLXATOnf70rPVNwmXM@lists.postgresql.org
X-Gm-Message-State: AOJu0YxXyD1U96RxeXmaowX68Yj0wBUzZ6rCSUTGn7eMTLgFRAh/q23i
	8WRmplCJyDKIn2BkUFHrjPGiybmytyUEv78dkO5fF4OLTKbkdUvv9dXtVAX9cg2QU755/L78ETM
	8HB7+v4D7Utz+99UvL+GMGj6Bks/g16g=
X-Gm-Gg: AfdE7ckmd48laIy5oQp8pGtax8THitYQfhJtITlRIT5ewOTPaLVtUlmgWpQsva9qA6K
	JnmSs2WEpaUFZJvxNod2QwoJQZ6ekVnLVIyM9knlhIRabxHygDpOTsa1SKLeqiv2eaO7yW0VB88
	FToiGBNG+TvGlv3QNxDrP0tis5C59CPgzY2INkkg82jB8oPLakycOzV3RkmpII3PmPK5gfZgL6p
	nwKTEvo8w5cikOUB2sUawyV851YjD00pgTEmTit3KcJeBs0Wi2o/lH2CXPxu1VjUdfRE+x7PBbE
	ICixtWca/PakgeXnvnu/AttFyPwVa5g1QnRWo/RTTUtzXN3Rx/7Mw9Wy0yD74pgbBS09fRC5aip
	k3zWHdJIr928E
X-Received: by 2002:a05:6214:5d81:b0:8fd:6e22:c7ea with SMTP id
 6a1803df08f44-8fec3908a88mr45232026d6.59.1783542587210; Wed, 08 Jul 2026
 13:29:47 -0700 (PDT)
MIME-Version: 1.0
References: <19536-73ce5847e6c0e7b1@postgresql.org>
 <CALj2ACVThKXik0+X12yEz=78uzUzLZABLj0WKOgH+q-kyvdDcg@mail.gmail.com>
 <CAEZATCW8q47GDba1o+Ji9JUhCHFFbB35D9qMSbBhboCx0GXkQQ@mail.gmail.com>
 <CALj2ACXYQrazMMXe_2bjfFx3DLOb0BDJ4hbx+1eprasX3x_+0A@mail.gmail.com>
 <CAEZATCWXA4fkO84u+i7KNS3PzC6ak4atnDAABHdax-H-jukU3w@mail.gmail.com>
 <CALj2ACXnez0hS_tMhviJRajUxZxbToqay4JJLp8QGSy_kPY9-w@mail.gmail.com>
In-Reply-To: 
 <CALj2ACXnez0hS_tMhviJRajUxZxbToqay4JJLp8QGSy_kPY9-w@mail.gmail.com>
From: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: Wed, 8 Jul 2026 21:29:35 +0100
X-Gm-Features: AUfX_mz_Boc5cR8Ng2G3Htzmy6yNZc4kSVVn5LS0nkUe7bhoLKubYcFfYIPqbBM
Message-ID: 
 <CAEZATCUv-szt_X8KuNTg2VQzxsoty8ojj2WtVX9OmCXQCLFD0Q@mail.gmail.com>
Subject: Re: BUG #19536: UPDATE RETURNING OLD value is stale after concurrent
 update when table has a BEFORE UPDATE trigger
To: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Cc: bobergj@gmail.com, pgsql-bugs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/CAEZATCUv-szt_X8KuNTg2VQzxsoty8ojj2WtVX9OmCXQCLFD0Q%40mail.gmail.com>
Precedence: bulk

On Tue, 7 Jul 2026 at 08:38, Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
>
> Sorry for the late response. I took a look at the v2 patch, tested it
> locally, and it looks good to me. I think we should backpatch this fix
> down to PG18 (commit 80feb727c86).
>

Thanks for reviewing.

Pushed and back-patched to v18.

Regards,
Dean