Oct 2021

1 commit
Fix checking of query type in plpgsql's RETURN QUERY command.
3 Oct 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14.1
LLM analysis, 100% surewritten from the discussion, no matching patch

Marc Bachmann reported that RETURN QUERY rejected INSERT RETURNING #8, and Tom Lane acknowledged the regression and announced the fix #9 #10. The commit adds SPIExecuteOptions.must_return_tuples, checks query result descriptors inside spi.c, and adds regression tests; neither attached patch contains this fix.

Jun 2020

1 commit
Avoid using a cursor in plpgsql's RETURN QUERY statement.
12 Jun 2020Tom Lanemaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #60 of 1 reviewer saw the final version

The commit matches the implementation across all nine files in #6. Differences are limited to doc/src/sgml/spi.sgml corrections and elaboration, plus comment wording in src/pl/plpgsql/src/pl_exec.c.

  • Hamid Akhtarsaw an earlier versionLLM analysis, 100% sureHamid reported successful installcheck-world and feature testing of #2 in #4, before the substantive ParamListInfo changes in #6, and the commit explicitly credits his review.

Credits across 2 commits

Author
Tom LaneLLM1
Committer
Tom Lane2

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