doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint)

Started by Naeem Akhter7 days ago5 messageshackers
Beta feature

Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.

won't retrysuccessCI history

This thread has been committed, so CI has stopped here. Anything below is the last result it produced.

You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:

docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t254215
psql -h localhost -U postgres

Built from patchset v1 (message #1), October 15, 2026 at 04:27 PM.

Every patchset is also pushed to a branch of our PostgreSQL fork, so you can check out the same tree CI built. Without a PostgreSQL checkout:

git clone --branch t254215_1 https://github.com/hackorum-dev/postgres.git

In a checkout you already have, add the fork once:

git remote add hackorum https://github.com/hackorum-dev/postgres.git

then, for this patchset and every later one:

git fetch hackorum t254215_1 && git checkout t254215_1

Patchset v1 (message #1) is on t254215_1

Jump to latest
#1Naeem Akhter
naeem.akhter@percona.com

Hi hackers,

func-info.sgml documents the num_mxids column of
pg_get_multixact_stats() as integer, but pg_proc.dat declares it int8
(bigint), and has since the function was added (97b101776ce). The
attached one-line patch fixes the doc.

The same doc text is reported in REL_19_STABLE, so this likely needs a
backpatch to 19 (I only checked master).

Regards,
Naeem Akhter
Percona

Attachments:

t254215_1
0001-doc-Fix-pg_get_multixact_stats-num_mxids-type.patchapplication/octet-stream; name=0001-doc-Fix-pg_get_multixact_stats-num_mxids-type.patchDownload+1-2
#2Naga Appani
nagnrik@gmail.com
In reply to: Naeem Akhter (#1)
Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint)

On Thu, Oct 15, 2026 at 11:13 AM Naeem Akhter <naeem.akhter@percona.com> wrote:

func-info.sgml documents the num_mxids column of
pg_get_multixact_stats() as integer, but pg_proc.dat declares it int8
(bigint), and has since the function was added (97b101776ce). The
attached one-line patch fixes the doc.

The same doc text is reported in REL_19_STABLE, so this likely needs a
backpatch to 19 (I only checked master).

Thanks for catching this and for the patch, Naeem! num_mxids is declared
int8 in pg_proc.dat, so "integer" in the docs was incorrect.

+1 on the backpatch to 19.

Thanks,
Naga

#3Fujii Masao
masao.fujii@gmail.com
In reply to: Naga Appani (#2)
Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint)

On Fri, Oct 16, 2026 at 1:53 AM Naga Appani <nagnrik@gmail.com> wrote:

Thanks for catching this and for the patch, Naeem! num_mxids is declared
int8 in pg_proc.dat, so "integer" in the docs was incorrect.

Shinoda-san previously reported the same issue and proposed a fix [1]/messages/by-id/LV8PR84MB3787CF6E56DCC99AE23E712EEE242@LV8PR84MB3787.NAMPRD84.PROD.OUTLOOK.COM,
but seems the patch was not committed unfortunately. Anyway, this fix
looks good to me, so I'll commit it.

Regards,

[1]: /messages/by-id/LV8PR84MB3787CF6E56DCC99AE23E712EEE242@LV8PR84MB3787.NAMPRD84.PROD.OUTLOOK.COM

--
Fujii Masao

#4Michael Paquier
michael@paquier.xyz
In reply to: Fujii Masao (#3)
Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint)

On Fri, Oct 16, 2026 at 02:32:48AM +0900, Fujii Masao wrote:

Shinoda-san previously reported the same issue and proposed a fix [1],
but seems the patch was not committed unfortunately. Anyway, this fix
looks good to me, so I'll commit it.

Thanks! The doc change sounds good here.
--
Michael

#5Fujii Masao
masao.fujii@gmail.com
In reply to: Michael Paquier (#4)
Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint)

On Fri, Oct 16, 2026 at 1:09 PM Michael Paquier <michael@paquier.xyz> wrote:

Thanks! The doc change sounds good here.

I've pushed the patch. Thanks!

Regards,

--
Fujii Masao