| From: | Nisha Moond <nisha(dot)moond412(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Subject: | Fix column privileges for pg_subscription.subwalrcvtimeout |
| Date: | 2026-06-01 13:44:12 |
| Message-ID: | CABdArM4uA=6nA0BunJwudiEoY1BcWUS_oj_2pkEq_d-YdiBJhw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Hackers,
IIUC, all columns of pg_subscription, except subconninfo, are intended
to be readable by non-superusers as well. A comment in
system_views.sql also states:
"-- All columns of pg_subscription except subconninfo are publicly readable."
However, 'subwalrcvtimeout' is currently not accessible:
Test:
postgres=# CREATE ROLE nisha LOGIN PASSWORD 'testpass';
CREATE ROLE
postgres=# SET SESSION AUTHORIZATION nisha;
SET
postgres=> select subwalrcvtimeout from pg_subscription;
ERROR: permission denied for table pg_subscription
It appears the column-level privileges for pg_subscription were not
updated when subwalrcvtimeout was added.
Attached is a small fix patch to grant public access to this column,
consistent with the existing behavior of the other pg_subscription
columns.
CC: Fujii-san (subwalrcvtimeout was introduced by commit fb80f38).
--
Thanks,
Nisha
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Fix-pg_subscription-column-privileges-for-subwalr.patch | application/octet-stream | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2026-06-01 14:00:27 | Re: should we have a fast-path planning for OLTP starjoins? |
| Previous Message | Jakob Egger | 2026-06-01 13:21:10 | Re: glob support in extension_control_path/dynamic_library_path? |