Prevent ALTER USER f RESET ALL from removing the settings that were put there

Alvaro Herrera <alvherre@alvh.no-ip.org>

Commit: 9a77104a266835384d5e7cb87c5c1592ef21b2c4
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2010-03-25T14:45:21Z
Releases: 8.2.17
Prevent ALTER USER f RESET ALL from removing the settings that were put there
by a superuser -- "ALTER USER f RESET setting" already disallows removing such a
setting.

Apply the same treatment to ALTER DATABASE d RESET ALL when run by a database
owner that's not superuser.

Files

PathChange+/−
src/backend/commands/dbcommands.c modified +25 −4
src/backend/commands/user.c modified +25 −3
src/backend/utils/misc/guc.c modified +82 −1
src/include/utils/guc.h modified +2 −1