Nov 2025

2 commits
Improve detection of implicitly-temporary views.
24 Nov 2025Tom Lanemaster19beta1REL_19_STABLE19beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #281 of 1 reviewer saw the final version

The implementation matches #28, including query_uses_temp_object(), the view and materialized-view checks, and removal of isQueryUsingTempRelation(). The commit adds materialized-view regression coverage and changes sequence-view tests to nextval() calls, as announced in #30.

  • Jim Jonessaw the final versiontrailerIn #29, Jim supported the view change, reported experimenting with it, and proposed materialized-view tests; only light test changes followed.
Issue a NOTICE if a created function depends on any temp objects.
23 Nov 2025Tom Lanemaster19beta1REL_19_STABLE19beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #271 of 1 reviewer saw the final version

Combines both patches from #27, preserving collectDependenciesOfExpr(), find_temp_object(), and the ProcedureCreate() NOTICE. Committer edits remove the error SQLSTATE, update comments, simplify tests, restore the isolation test, and omit the returning.sql schema rearrangement, consistent with #28.

  • Tom Lanesaw the final versiontrailerTom challenged the initial design, directed dependency collection in #14 and #17, broadened the implementation in #19, and edited and committed the final submission as reported in #28.

Credits across 2 commits

Author
Jim Jones1
Tom Lane1
Reviewer
Jim Jones1
Tom Lane1
Committer
Tom Lane2