SET ROLE documentation improvement

Yurii Rashkovskii <yrashk@gmail.com>

From: Yurii Rashkovskii <yrashk@gmail.com>

To: pgsql-hackers@lists.postgresql.org

Date: 2023-09-15T18:26:16Z

Lists: pgsql-hackers

Attachments

0001-Minor-improvement-to-SET-ROLE-documentation.patch (application/octet-stream) patch 0001

Hi,

I believe SET ROLE documentation makes a slightly incomplete statement
about what happens when a superuser uses SET ROLE.

The documentation reading suggests that the superuser would lose all their
privileges. However, they still retain the ability to use `SET ROLE` again.

The attached patch adds this bit to the documentation.

-- 
Y.

Commits

doc: Note exceptions for SET ROLE's effect on privilege checks.
- 953cf49e166a 17.0 landed
doc: Clarify requirements for SET ROLE.
- d82dc79ba03c 16.3 landed
- 3330a8d1b792 17.0 landed