Horton

Fix pg_subscription column privileges for subwalrcvtimeout

Fujii Masao <fujii@postgresql.org>

View on postgr.es
Commit: 1a5b19e447aa6c2743371dc559f697cf63c7ba82
Author: Fujii Masao <fujii@postgresql.org>
Date: 2026-06-05T00:51:55Z
Releases: 19 (unreleased) 
Fix pg_subscription column privileges for subwalrcvtimeout

The subwalrcvtimeout column was added by commit fb80f38, but the
column-level privileges on pg_subscription were not updated. As a
result, non-superusers cannot read the column, unlike the other
publicly readable pg_subscription columns.

This commit grants SELECT privilege on subwalrcvtimeout to PUBLIC.

Bump catalog version.

Author: Nisha Moond <nisha.moond412@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/CABdArM4uA=6nA0BunJwudiEoY1BcWUS_oj_2pkEq_d-YdiBJhw@mail.gmail.com

Files

PathChange+/−
src/backend/catalog/system_views.sql modified +2 −1
src/include/catalog/catversion.h modified +1 −1
src/test/regress/expected/subscription.out modified +15 −0
src/test/regress/sql/subscription.sql modified +11 −0

Discussion