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-hackers-owner+archive@lists.postgresql.org>)
	id 1vp2NP-0002gQ-14
	for pgsql-hackers@arkaria.postgresql.org;
	Sun, 08 Feb 2026 10:50:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vp2NO-007w1g-0p
	for pgsql-hackers@arkaria.postgresql.org;
	Sun, 08 Feb 2026 10:50: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 <alvherre@kurilemu.de>)
	id 1vp2NN-007w1S-0w
	for pgsql-hackers@lists.postgresql.org;
	Sun, 08 Feb 2026 10:50:49 +0000
Received: from fhigh-b5-smtp.messagingengine.com ([202.12.124.156])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <alvherre@kurilemu.de>)
	id 1vp2NL-000000017OS-041s
	for pgsql-hackers@lists.postgresql.org;
	Sun, 08 Feb 2026 10:50:48 +0000
Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44])
	by mailfhigh.stl.internal (Postfix) with ESMTP id 6E2707A0119;
	Sun,  8 Feb 2026 05:50:45 -0500 (EST)
Received: from phl-imap-17 ([10.202.2.105])
  by phl-compute-04.internal (MEProxy); Sun, 08 Feb 2026 05:50:45 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm1; t=1770547845;
	 x=1770634245; bh=nQQyUFkggJgNsVNHFJqZybLTvy5syDQ7izLhV0HerlA=; b=
	yDHQkmydDIB99QNxbL/WgMLJweZ7awvE8QupzVrmG0MDzG3WjVY3rltX2Zf0BvgP
	WanpvvHkNU3TcO+44qh78oA7Zg3ep2SJ/h3R1114omnAwHanJjmJfv+RqKugMOVE
	dReqensHNlV/RZDLX+z9w9pALI8pZFvDfWzEMlcF/PODMKGKxxNPqrv85akPtKYj
	3IFOYmkQ6WnqykwADTCP9ICTLkPw9x3Nb/14LcHlmPZZOWZgEs3d3vp0kS55GGbM
	Dg0BarHv860Imna1y0cM/4LY3uh2HsDE+I/t5a5Gu8jc9bVJIDMzXd/v9UpWVXEA
	B/gdldK1Oe+3JjYT2Sd72A==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-sender
	:x-me-sender:x-sasl-enc; s=fm3; t=1770547845; x=1770634245; bh=n
	QQyUFkggJgNsVNHFJqZybLTvy5syDQ7izLhV0HerlA=; b=NsDB8C/vinpXKE5+O
	MD5T3w/YK6U+uW6Pf5FgwiXhrYuiz9ITO7Cf0aWjoVVRS7AxN6nrfgnzDDPfd0wN
	SRVfwO5B9R5bltuoJeV5o801u+MsEUbg69BnX+QMZsbW6nTx2PkL0Vg2mu5YW/Di
	ZIar84ayMPE7+6jGtIRfFXkHYK8LKBx3HJ6mc/P51zCgGVX4HAaHFccHtQYpspaR
	R0tckZnAJwH2Xt5Fe1rYsuNchL2kQfTIRWHK9ybopr8oYeID8M6qjKI9eyF96ToJ
	PN6lWuB1SEFj1X7c7HdCQqRz2Y0x1UC2zSmBdoDIdWbJIF10F/UdJSYYYbQH0oep
	gbfYw==
X-ME-Sender: <xms:hGqIaXXFiRnuRlJn2Ln5fPaWH_x4F3XtEOp-9o5iwddmpwP_HdFFFQ>
    <xme:hGqIaaYEewDP8Wxa6RLXLkmuq2J-gLsS9W9g769uGfELoVxziBnU7UledsRMFtcx9
    -3jAnx3W7o9mEzY8NafwS-Ma8zlY5vaZ87JK91sgW0DgfnIttp_>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduleefjeefucetufdoteggodetrf
    dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu
    rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf
    gurhepofggfffhvffkjghfufgtgfesthhqredtredtjeenucfhrhhomheplmhlvhgrrhho
    ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtf
    frrghtthgvrhhnpeeigfegfeelvddtveelffehvdefveelffdvfeethfeufeeftdejgeei
    hfdtgfettdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhroh
    hmpegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgdpnhgspghrtghpthhtohepvddp
    mhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepshhhihhnhigruddurdhkrghtohesgh
    hmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehlihhsthhs
    rdhpohhsthhgrhgvshhqlhdrohhrgh
X-ME-Proxy: <xmx:hGqIaeBz1ONasj-XPuM2dDvco802uita_yNm80KkqlpqW73WtAe4ZQ>
    <xmx:hGqIaWff6htnx5knp7Xf3FluH_NtwJ8jlpG3mcGykId4t6MHH52mPQ>
    <xmx:hGqIaZImchYeVXyz9fjxMQqfURX1DKdTLt_zjBdYJmFUyMLtVvLcGw>
    <xmx:hGqIaZeDceV5XC5YAirYEeWyl0kEOGSdiSm1mmgSbRCqPfz3upk7bA>
    <xmx:hWqIaZ3BWH5OQWOrpIPWkX-LFlSmvJ31KzSfUD_stEe_9uFZNkaKtkbT>
Feedback-ID: ie3de48e3:Fastmail
Received: by mailuser.phl.internal (Postfix, from userid 501)
	id BB625C40071; Sun,  8 Feb 2026 05:50:44 -0500 (EST)
X-Mailer: MessagingEngine.com Webmail Interface
MIME-Version: 1.0
X-ThreadId: Aqtd5hTx2XTg
Date: Sun, 08 Feb 2026 11:50:24 +0100
From: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>
To: "Shinya Kato" <shinya11.kato@gmail.com>,
 pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Message-Id: <9697ad60-ec88-4446-89c1-dc02a3b8e89c@app.fastmail.com>
In-Reply-To: 
 <CAOzEurQetW=-1+OnMo8baeVQF=-kAr-wNtFcgRNo+ErPk=xsDQ@mail.gmail.com>
References: 
 <CAOzEurQetW=-1+OnMo8baeVQF=-kAr-wNtFcgRNo+ErPk=xsDQ@mail.gmail.com>
Subject: Re: Use pg_current_xact_id() instead of deprecated txid_current()
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/9697ad60-ec88-4446-89c1-dc02a3b8e89c%40app.fastmail.com>
Precedence: bulk

On 2026-02-08, Shinya Kato wrote:

> Since pg_current_xact_id() returns xid8 which does not support
> arithmetic operators, places that need "xid + 1" cast the result via
> ::text::bigint first.

I think it may be better to add some operators, or was there a rationale=
 for these not being there?

--=20
=C3=81lvaro Herrera