model-writtenrun 6018 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Jeff Davis proposed allowing pg_signal_backend members to call pg_log_backend_memory_contexts(), replacing its hardcoded superuser check with SQL function privileges because the operation uses a signal #1.
- Nathan Bossart raised the predefined role's prohibition on signaling superuser-owned backends, Michael Paquier identified documentation and regression-role naming requirements, and Bharath Rupireddy requested stronger privilege testing; Jeff revised the patch to protect superuser backends and address documentation and role names #2 #3 #4 #5.
- Jeff left pg_reload_conf() and pg_rotate_logfile() unchanged because they signal the postmaster and already support GRANT, and kept the memory-context tests together in misc_functions.sql #5 #6.
- Kyotaro Horiguchi objected to coupling memory logging with session-termination privileges, Michael advocated separating function grants from predefined-role policy, and Andres Freund argued that signaling was an implementation detail; although Bharath suggested alternative predefined roles, Jeff dropped the automatic role grant and posted an explicit-GRANT revision retaining the superuser-target restriction #10 #11 #12 #16 #17.
- Nathan approved the revised patch, but Andres challenged its remaining restriction because it prevented monitoring all backends; Jeff offered to remove that check, and Nathan agreed that it was unnecessary once the pg_signal_backend grant was gone #18 #19 #20 #21.
- Fujii Masao requested documentation explaining that other users could receive EXECUTE permission, and Jeff explained that the introduction above the function table already covered this behavior #22 #23.
- Jeff committed f0b051e322 from #17 with the remaining target restriction removed and corresponding test and documentation adjustments; his final message confirmed that execution remains restricted by default but administrators can grant it to non-superusers, completing the narrowed change #23.