RE: [PATCH] New default role allowing to change per-role/database settings

>Thanks for letting me know, I've attached a rebased v4 of this patch, no other
>changes.
I tried it, but when I used set command, tab completion did not work properly and an error occurred.

---
postgres=> \conninfo
You are connected to database "postgres" as user "aaa" via socket in "/tmp" at port "5432".
postgres=> \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+---------------------------
aaa | | {pg_change_role_settings}
penguin | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
postgres=> show log
log_autovacuum_min_duration log_executor_stats log_min_error_statement log_replication_commands log_timezone
log_checkpoints log_file_mode log_min_messages log_rotation_age log_transaction_sample_rate
log_connections log_hostname log_parameter_max_length log_rotation_size log_truncate_on_rotation
log_destination log_line_prefix log_parameter_max_length_on_error log_statement logging_collector
log_disconnections log_lock_waits log_parser_stats log_statement_sample_rate logical_decoding_work_mem
log_duration log_min_duration_sample log_planner_stats log_statement_stats
log_error_verbosity log_min_duration_statement log_recovery_conflict_waits log_temp_files
postgres=> show log_duration ;
log_duration
--------------
off
(1 row)

postgres=> set log
log_parameter_max_length_on_error logical_decoding_work_mem
postgres=> set log_duration to on;
2021-09-08 16:23:39.216 JST [533860] ERROR: permission denied to set parameter "log_duration"
2021-09-08 16:23:39.216 JST [533860] STATEMENT: set log_duration to on;
ERROR: permission denied to set parameter "log_duration"
---

Regards,

--
Shinya Kato
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION