Horton

Clarify documentation of RESET ROLE

Joe Conway <mail@joeconway.com>

View on postgr.es
Commit: 9e67a9440736be87d4013ce2d23faa131523c07e
Author: Joe Conway <mail@joeconway.com>
Date: 2021-04-02T17:48:56Z
Releases: 9.6.22 
Clarify documentation of RESET ROLE

Command-line options, or previous "ALTER (ROLE|DATABASE) ...
SET ROLE ..." commands, can change the value of the default role
for a session. In the presence of one of these, RESET ROLE will
change the current user identifier to the default role rather
than the session user identifier. Fix the documentation to
reflect this reality. Backpatch to all supported versions.

Author: Nathan Bossart
Reviewed-By: Laurenz Albe, David G. Johnston, Joe Conway
Reported by: Nathan Bossart
Discussion: https://postgr.es/m/flat/925134DB-8212-4F60-8AB1-B1231D750CB4%40amazon.com
Backpatch-through: 9.6

Files

PathChange+/−
doc/src/sgml/ref/set_role.sgml modified +10 −3

Documentation touched

Discussion

Cited messages not in the archive: flat/925134DB-8212-4F60-8AB1-B1231D750CB4@amazon.com