But after applying the patch i can be able to apply all the results except the reset options user variables
postgres=# alter role bob in DATABASE postgres reset ALL
also i cross verified that my system doesn't have variables so it returns 0 rows?but:
postgres=# SELECT name FROM pg_settings LIMIT 5; name ---------------------------- allow_alter_system allow_in_place_tablespaces allow_system_table_mods application_name archive_cleanup_command (5 rows)
The tab-completion here queries the user-specific config (not the global pg_settings). I believe the underlying code logic will help explain this behavior:
#define Query_for_list_of_user_vars \ "SELECT conf FROM ("\ " SELECT rolname, pg_catalog.split_part(pg_catalog.unnest(rolconfig),'=',1) conf"\ " FROM pg_catalog.pg_roles"\ " ) s"\ " WHERE s.conf like '%s' "\ " AND s.rolname LIKE '%s'"
