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 1vgQJP-00CIh3-2M
	for pgsql-bugs@arkaria.postgresql.org;
	Thu, 15 Jan 2026 16:35:08 +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 1vgQJN-000VXJ-1A
	for pgsql-bugs@arkaria.postgresql.org;
	Thu, 15 Jan 2026 16:35:05 +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 1vgQJN-000VXA-0I
	for pgsql-bugs@lists.postgresql.org;
	Thu, 15 Jan 2026 16:35:05 +0000
Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <dean.a.rasheed@gmail.com>)
	id 1vgQJK-000apH-2x
	for pgsql-bugs@lists.postgresql.org;
	Thu, 15 Jan 2026 16:35:04 +0000
Received: by mail-oo1-xc29.google.com with SMTP id 006d021491bc7-65cf050a5cdso1223970eaf.1
        for <pgsql-bugs@lists.postgresql.org>; Thu, 15 Jan 2026 08:35:03 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1768494903; x=1769099703; darn=lists.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=AIz5bZmj2sLBqqJxYypH33nj+AzkrJr81kbWdXdIIiA=;
        b=X/7eKKQMqCUbEkHx9ov1XHkwSnFRiRfcFi46ruVKU21csNXtOpVItAc+KXnUJtimQA
         O7zT3TXUQk3Z6OSkxpQfLHDixqnP2NL2sA+TIGL3anhTvRgtZTVJNR+NEbm/oYdVqvan
         rDsniMsEN6b1eu6KXVervzCTnMA0i5Ll2QPgdmzbTH81hAsL43CqTT6v21tgc38SMSNu
         q7zJv4OUGnT0/BXZksv8+M3KalCVbhtd2KuEeP4K6IkCeevzIUT5Mzdp3+nOZYRhRQcO
         W1sv7x/4IUH2ZVOs2tqAUv63ra/Zv3EXUnhHC9ST4NSH5umVdqxTCSKGBzxanXg0MVCR
         i9sg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1768494903; x=1769099703;
        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=AIz5bZmj2sLBqqJxYypH33nj+AzkrJr81kbWdXdIIiA=;
        b=O3G9xGpXn8sI7PFv+mNQNtVvk3eYj7lZ0I3b/vDeAxlmZN2wJMJPmngcdFqG+ncGAE
         03Qk2asnB8MTCtgxzudQq/DSTLbuhwBC2LiU/nXDDAtBa/fg4zy4MA97hE+LGgjWU7mS
         rCdl5lHgEV9IxbJ/SgPNgVUY6embGYyuMoGU8xQqnICXRNoXC7U4p117Hmi2eMiOwmAz
         JtBn8CLjLG1e91bXyCmlLqgv73Nx53pE3w9bNI0lWvN02CLBE/tQG+yfIRiV6fRvS1Ok
         rSiLh5QgPesmnRyBH3DWHfGbZDY3+hzyi+Kc7C3lf1H9ge/eDhPXO3WbXoh5UU9WLCj8
         OAkA==
X-Forwarded-Encrypted: i=1; AJvYcCUMICJtwJNPtZsCi9iyiNbkRqd0Glg9a4sb6KtqA3LWPw/zOCIe2O15jt3VymQq9NrUwCELt2oHGuhG@lists.postgresql.org
X-Gm-Message-State: AOJu0YyPjYIu930Uj2YRECmwBuXTw8FwcGWzkNi/HisJM0Rlg9e8P9nq
	38YuAgIlHmBnXk0N4XF6O3+a5zB5M0f+JguM41idiqKEwra/bv7bk55nhKO1ptPPLi3ghC+ZVY9
	DpZRqIcrehjEpy2hfkWG36GnYup650VA=
X-Gm-Gg: AY/fxX51mfl+Uh6DpNxmuUP06Lu+lHUmbx84BZEBhe8mO90MHO1gKSecZ56gve145ee
	Ojcew6a8VF3UAi37nZmLo4OewFzqRP0UUSFceGp2QBhTdXEL8KDrpgOSmEiLUScYWzlMchA21+M
	gfdIRzGnZvejec2gSuz5ydnyK4HS4yFPDmKn/9Zujk+GcIwQ5S7P5+bH2Egt6RzVmI1L+Jui3lT
	0F2W3Zij92efNQtd173ejMt3MJN0QxPua6+zgzoykOa9d+D3GSBQ/K1GrsqluWUhN+BhP5glyqd
	TiMySnhBIWQw7j565pVNqVY3FVLNIQ==
X-Received: by 2002:a4a:dd95:0:b0:65f:552e:2ceb with SMTP id
 006d021491bc7-6610e62603cmr2093220eaf.25.1768494902945; Thu, 15 Jan 2026
 08:35:02 -0800 (PST)
MIME-Version: 1.0
References: <19355-57d7d52ea4980dc6@postgresql.org> <868ff2a518820c8864b6d28510294b2457a126af.camel@cybertec.at>
 <CANjBVm3AMm=9-mB7=uqJjaWN-+RrA8+w-gXhZn6L7VHu7K_Urw@mail.gmail.com>
 <CAEZATCVcV4cfqGnmPGVxwjsPh7rxsTD510=KOGFyi2_FMgqWaQ@mail.gmail.com>
 <CA+HiwqE8gNK7Utqo2EAKh24KExWfypt06m1EFNXBd5TFDO2f6w@mail.gmail.com>
 <CAHewXNn8ApcYfZKjZ1R8Z7yHRoi+C+mu5r9LbZUbb6691d6Rrw@mail.gmail.com>
 <CAEZATCVr+=F=iTbi3XyABSEr5Cqw=ptm2PyGc75SaQ1JYrPnsg@mail.gmail.com>
 <CA+HiwqGCfYgT1DnnK836qRX63okKNeNR=CQmshC6=aATCw6VVA@mail.gmail.com>
 <CAEZATCVwnjNYNSLLTQCXgwhgGEascKHu+hEtDVn7PF4ZCZvm8g@mail.gmail.com>
 <CA+HiwqFC8OssEd-sAixUiZetiMGz8BGbbn6GJC8krUQx2J=huQ@mail.gmail.com> <CA+HiwqGSogk5__9rFp9F6TGDpyM11CTVQHy5GRptGZC3A4DwwA@mail.gmail.com>
In-Reply-To: <CA+HiwqGSogk5__9rFp9F6TGDpyM11CTVQHy5GRptGZC3A4DwwA@mail.gmail.com>
From: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: Thu, 15 Jan 2026 16:34:51 +0000
X-Gm-Features: AZwV_Qgdujp3n8nPzENTd7FKC_b-W_XRoYykIM4tdD4cwqahE6Y5j2CQgFKefe0
Message-ID: <CAEZATCWzrmzt37t-1GBGsswoXjWqzCNpxgvq6eJhhQOitxW31A@mail.gmail.com>
Subject: Re: BUG #19355: Attempt to insert data unexpectedly during concurrent update
To: Amit Langote <amitlangote09@gmail.com>
Cc: Tender Wang <tndrwang@gmail.com>, Bh W <wangbihua.cn@gmail.com>, 
	Laurenz Albe <laurenz.albe@cybertec.at>, 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/CAEZATCWzrmzt37t-1GBGsswoXjWqzCNpxgvq6eJhhQOitxW31A%40mail.gmail.com>
Precedence: bulk

On Thu, 15 Jan 2026 at 11:39, Amit Langote <amitlangote09@gmail.com> wrote:
>
> Here's Dean patch with a commit message added.  I plan to commit it
> barring objections.
>

Commit message LGTM.

Regards,
Dean