SHOW ALL does not honor pg_read_all_settings membership

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>

To: pgsql-hackers@postgresql.org

Date: 2018-03-01T15:22:38Z

Lists: pgsql-hackers

Attachments

0001-Teach-SHOW-ALL-to-honor-pg_read_all_settings-members.patch (text/x-patch) patch 0001

I noticed that commit 25fff40798fc4ac11a241bfd9ab0c45c085e2212 forgot
to teach SHOW ALL to show all GUCs when the user belongs to pg_read_all_settings.

Patch attached; I think this should be backpatched.

Yours,
Laurenz Albe

Commits

Teach SHOW ALL to honor pg_read_all_settings membership
- a25c207b2fb8 10.5 landed
- 0c8910a0cab7 11.0 landed
Default monitoring roles
- 25fff40798fc 10.0 cited