Feedback-ID: i0fe9450f:Fastmail
Date: Fri, 9 Jan 2026 09:25:01 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Pavlo Golub <pavlo.golub@cybertec.at>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: [PATCH] Add pg_current_vxact_id() function to expose virtual
 transaction IDs
Message-ID: <aWBK3fVZk4cgPPJq@paquier.xyz>
References: <em5af9cba4-8cd3-4c9a-a593-c985d1c373ee@18a0083a.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="vVsDsM2h+erj4XLB"
Content-Disposition: inline
In-Reply-To: <em5af9cba4-8cd3-4c9a-a593-c985d1c373ee@18a0083a.com>
Archived-At: <https://www.postgresql.org/message-id/aWBK3fVZk4cgPPJq%40paquier.xyz>
Precedence: bulk


--vVsDsM2h+erj4XLB
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Mon, Dec 08, 2025 at 12:09:58PM +0000, Pavlo Golub wrote:
> Virtual transaction IDs are fundamental to PostgreSQL's transaction
> tracking,
> appearing in pg_locks.virtualtransaction, log output via %v placeholder, and
> internal transaction management. However, there's currently no direct SQL
> function to retrieve the current VXID, forcing applications to query
> pg_locks
> or parse log files to obtain this information.

This is replacing one SQL in a given session by another, as a session
currently running a transaction can query itself pg_locks and match an
entry with its own pg_backend_pid().  Hence I don't see the need for
this function, except simplicity in retrieving a session's state with
less characters typed at the end?

Thoughts and opinions from others are welcome.  I'm always OK to be
outvoted.
--
Michael

--vVsDsM2h+erj4XLB
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmlgSt0ACgkQnvQgOdby
QH0yiQ/8DOQ5YoPXpLZr+vASRN2jvIx9IbRLYCSwgdwO3bsPXQ4onK+HIpWqOcKc
ITN5bao/nitDWQsJjJ/n0K7sxNRvfCb1MruGS+hDpQZJeUmtBIlApeJftGJOLT3l
5mCD1/w5aKhzc9yGGrmQ7NVD3upQFv4XYn0dnHzojgAR00bgacIZLgT7xsahF1SX
WbY89QTDwKVscqFa3IPC0jOk5yDKeLV3TNRleNS2DFW6+C7EUf+XwJ0Ch6C7wswY
uzLJhBt6VpbIid+zS2IFP9EFMYCQ691peG/ICNK64rQETADS39QhUwEf/ZOSFf2f
Zt3aQGT0muICQ/oKjNlR87SDpetyu9BFL33jyXgdAvQb/Z7lAat5QjeF9chmnQb2
MaQkOXkcGPyI3agIR/V1vxVMRVWyPIsmBCh/1obpYsPX6lbdFuwSdrnlpxTemgkI
mWO5NcwvcnvMk5w4pvaBc0LGgxYvk/yG/4/JVNjHKvFVTf1uYpKOVqyQ5jdtwl1n
mHIhAW9Sr7UWRUfa8KI/z1j0f/zOyYpi1WV5rKQ3iaBv07Q4haq6d07mdOJKqBfn
FgfSp3dvh7cJN08hJoaGEBSNc9FwbIN1bZLRl+zL84Ym3Kc7PyWTr8s3asqXqn8o
SIvxfMm4Dpp66Z5JoiVTAwMDhO/7vq348A7oFcus541zCsH+s3g=
=QEjI
-----END PGP SIGNATURE-----

--vVsDsM2h+erj4XLB--