Re: Add a permission check to pg_stat_get_backend_subxact() - Mailing list pgsql-hackers

On Thu, Sep 24, 2026 at 11:40:01PM -0400, shihao zhong wrote:
> One more point for Michael. 0002 does not change stats_fetch_consistency
> or drop anything fetched earlier. It only checks, while the activity
> snapshot is built, that each entry takes its status and its PGPROC fields
> from the same backend. If the PID does not match, that backend has exited,
> so no xid and no subxacts is the right answer for it.

Let me doubt you here.  For one, it makes the API contract of
ProcNumberGetTransactionIds() much harder to think about.
--
Michael