Jan 2021

2 commits
Rethink recently-added SPI interfaces.
26 Jan 2021Tom Lanemaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% surewritten from the discussion, no matching patch

Tom proposes replacing SPI_execute_with_receiver with SPI_execute_extended sharing the execution-options struct in #9, without attaching a patch. The commit implements that follow-up and similarly converts SPI_cursor_parse_open_with_paramlist to SPI_cursor_parse_open, updating spi.c, spi.h, PL/pgSQL callers and documentation.

Improve performance of repeated CALLs within plpgsql procedures.
26 Jan 2021Tom Lanemaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitmoderate changesfrom patchset #81 of 1 reviewer saw the final version

Implements #8's cached CALL/DO plans, explicit plancache ownership and conditional procedure resource owner; Tom confirms committing with cleanup in #9. Beyond naming and comments, it expands SPIExecuteOptions to include parameters and snapshot control, removes SPI_execute_plan_with_receiver, and reuses the inline handler's existing resource owner instead of allocating another.

  • Tom Lanesaw the final versioncommittercommitted the patch

Credits across 2 commits

Author
Pavel StehuleLLM1
Reviewer
Tom Lanecommitter1
Committer
Tom Lane2

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