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 <[email protected]>
Reviewed-by: Amit Kapila <[email protected]>
Reviewed-by: Fujii Masao <[email protected]>
Discussion: 
https://postgr.es/m/CABdArM4uA=6na0bunjwudieoy1bcwus_oj_2pkeq_d-ydib...@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/1a5b19e447aa6c2743371dc559f697cf63c7ba82

Modified Files
--------------
src/backend/catalog/system_views.sql       |  3 ++-
src/include/catalog/catversion.h           |  2 +-
src/test/regress/expected/subscription.out | 15 +++++++++++++++
src/test/regress/sql/subscription.sql      | 11 +++++++++++
4 files changed, 29 insertions(+), 2 deletions(-)

Reply via email to