Jun 2021

2 commits
Force NO SCROLL for plpgsql's implicit cursors.
8 Jun 2021Tom Lanemaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2REL_13_STABLE13.4+2 more
LLM analysis, 99% surewritten from the discussion, no matching patch

be90098907 follows up the unstable-cursor problem discussed in #2 and #3 by forcing CURSOR_OPT_NO_SCROLL for implicit PL/pgSQL cursors in src/pl/plpgsql/src/pl_exec.c. These changes are absent from the attached patch, and the commit explicitly attributes them to further thought about this bug.

Avoid misbehavior when persisting a non-stable cursor.
8 Jun 2021Tom Lanemaster14beta2REL_19_STABLE14beta2REL_18_STABLE14beta2REL_17_STABLE14beta2REL_16_STABLE14beta2REL_15_STABLE14beta2REL_14_STABLE14beta2REL_13_STABLE13.4+2 more
LLM analysis, 100% suremodified before commitlight changesfrom patchset #3

ba2c6d6cec preserves the portalcmds.c implementation and explicit-cursor regression test from #3. It adds an implicit-cursor regression case and documentation in doc/src/sgml/plpgsql.sgml and doc/src/sgml/ref/declare.sgml, without changing the posted implementation.

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.