Sep 2021

2 commits
Disallow LISTEN in background workers.
15 Sep 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14rc1REL_13_STABLE13.5
LLM analysis, 100% surelanded as postedfrom patchset #241 of 1 reviewer saw the final version

The commit diff exactly matches #24 after excluding index-hash abbreviation differences: src/backend/tcop/utility.c rejects LISTEN when MyBackendType is not B_BACKEND.

  • Arthur Zakirovsaw the final versionLLM analysis, 100% sureBefore the commit, Arthur endorsed #24 in #25, agreeing that processes unable to deliver notifications to frontends should not support LISTEN.
Send NOTIFY signals during CommitTransaction.
14 Sep 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14rc1REL_13_STABLE13.5
LLM analysis, 100% surelanded as postedfrom patchset #231 of 5 reviewers saw the final version

The five-file commit diff exactly matches #23 after excluding index-hash abbreviation differences. The commit credits Artur Zakirov and Tom Lane, reflecting Arthur's implementation in #18 and #21 followed by Tom's consolidation of notification processing.

  • Andres Freundsaw an earlier versionLLM analysis, 99% sureAndres reviewed #5 in #6, proposed moving signaling into transaction commit, and identified the background-worker queue-cleanup problem in #9 and #11, before substantial reworking.
  • Michael Powerssaw an earlier versionLLM analysis, 100% sureMichael reported in #7 that testing #5 resolved his reproduction, before the implementation was substantially reworked.
  • Robert Welinsaw an earlier versionLLM analysis, 96% sureRobert reported in #12 that the issue persisted even with #5, providing a negative test result on the earlier implementation.
  • Sergey Fedchenkosaw an earlier versionLLM analysis, 91% sureSergey reported in #17 that adapting #5 for PostgreSQL 14 beta and testing with a Go client resolved the bug, before the commit-time implementation replaced it.
  • Tom Lanesaw the final versioncommittercommitted the patch

Credits across 2 commits

Author
Arthur ZakirovLLM1
Tom LaneLLM1
Reviewer
Tom Lanecommitter1
Committer
Tom Lane2

N LLM means N of the credits come from LLM analysis, not from commit trailers.