agora inbox for pgsql-committers@postgresql.orghelp / color / mirror / Atom feed
pgsql: Fix pg_stat_progress_cluster command reporting for unprivileged 2+ messages / 1 participants [nested] [flat]
* pgsql: Fix pg_stat_progress_cluster command reporting for unprivileged @ 2026-09-10 02:55 Fujii Masao <fujii@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Fujii Masao @ 2026-09-10 02:55 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix pg_stat_progress_cluster command reporting for unprivileged users Previously, when another session ran REPACK, CLUSTER, or VACUUM FULL and the user lacked permission to view its progress details, pg_stat_progress_cluster incorrectly reported the command as CLUSTER instead of NULL. pg_stat_progress_cluster is based on pg_stat_progress_repack and translates REPACK into CLUSTER or VACUUM FULL depending on whether index ordering is requested. However, this translation defaulted to CLUSTER, incorrectly converting NULL commands returned for insufficient privileges into CLUSTER. Fix this translation to preserve a NULL command when the user lacks permission to view the progress details. Bump catalog version. Author: Zsolt Parragi <zsolt.parragi@percona.com> Reviewed-by: Fujii Masao <masao.fujii@gmail.com> Reviewed-by: Chao Li <lic@highgo.com> Discussion: https://postgr.es/m/CAN4CZFMzy2V_wvRCBW5K8=wVCk1-C7nq=8otXO=u+s_1KZHqyA@mail.gmail.com Backpatch-through: 19 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/054c1c3e650b2fe0c44570a59bc4ea05bd2ac142 Modified Files -------------- src/backend/catalog/system_views.sql | 5 +++-- src/include/catalog/catversion.h | 2 +- src/test/regress/expected/rules.out | 5 +++-- 3 files changed, 7 insertions(+), 5 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Fix pg_stat_progress_cluster command reporting for unprivileged @ 2026-09-10 02:56 Fujii Masao <fujii@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Fujii Masao @ 2026-09-10 02:56 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix pg_stat_progress_cluster command reporting for unprivileged users Previously, when another session ran REPACK, CLUSTER, or VACUUM FULL and the user lacked permission to view its progress details, pg_stat_progress_cluster incorrectly reported the command as CLUSTER instead of NULL. pg_stat_progress_cluster is based on pg_stat_progress_repack and translates REPACK into CLUSTER or VACUUM FULL depending on whether index ordering is requested. However, this translation defaulted to CLUSTER, incorrectly converting NULL commands returned for insufficient privileges into CLUSTER. Fix this translation to preserve a NULL command when the user lacks permission to view the progress details. Bump catalog version. Author: Zsolt Parragi <zsolt.parragi@percona.com> Reviewed-by: Fujii Masao <masao.fujii@gmail.com> Reviewed-by: Chao Li <lic@highgo.com> Discussion: https://postgr.es/m/CAN4CZFMzy2V_wvRCBW5K8=wVCk1-C7nq=8otXO=u+s_1KZHqyA@mail.gmail.com Backpatch-through: 19 Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/d1f742d5d12654173b022fd7723ab206a3e3a3de Modified Files -------------- src/backend/catalog/system_views.sql | 5 +++-- src/include/catalog/catversion.h | 2 +- src/test/regress/expected/rules.out | 5 +++-- 3 files changed, 7 insertions(+), 5 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-09-10 02:56 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-09-10 02:55 pgsql: Fix pg_stat_progress_cluster command reporting for unprivileged Fujii Masao <fujii@postgresql.org> 2026-09-10 02:56 pgsql: Fix pg_stat_progress_cluster command reporting for unprivileged Fujii Masao <fujii@postgresql.org>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox