Commits

Showing commits that first shipped in 14 (backpatches included). Clear

DateSubjectAuthorReleases
2025-11-29 Avoid rewriting data-modifying CTEs more than once. Dean Rasheed 14.21
2025-11-18 Don't allow CTEs to determine semantic levels of aggregates. Tom Lane 14.21
2025-09-17 Calculate agglevelsup correctly when Aggref contains a CTE. Tom Lane 14.20
2025-04-05 Fix parse_cte.c's failure to examine sub-WITHs in DML statements. Tom Lane 14.18
2024-12-19 Fix Assert failure in WITH RECURSIVE UNION queries David Rowley 14.16
2024-07-14 Avoid unhelpful internal error for incorrect recursive-WITH queries. Tom Lane 14.13
2022-12-16 Fix inability to reference CYCLE column from inside its CTE. Tom Lane 14.7
2022-10-16 Fix EXPLAIN of SEARCH BREADTH FIRST with a constant initial value. Tom Lane 14.6
2022-05-18 Check column list length in XMLTABLE/JSON_TABLE alias Alvaro Herrera 14.4
2022-04-23 Fix incautious CTE matching in rewriteSearchAndCycle(). Tom Lane 14.3
2022-04-21 Remove inadequate assertion check in CTE inlining. Tom Lane 14.3
2021-12-30 Fix overly generic name in with.sql test. Thomas Munro 14.2
2021-09-16 Fix EXPLAIN to handle SEARCH BREADTH FIRST queries. Tom Lane 14.0
2021-09-08 Fix rewriter to set hasModifyingCTE correctly on rewritten queries. Tom Lane 14.0
2021-07-09 Reject cases where a query in WITH rewrites to just NOTIFY. Tom Lane 14.0
2021-02-27 Enhanced cycle mark values Peter Eisentraut 14.0
2021-02-26 Fix list-manipulation bug in WITH RECURSIVE processing. Tom Lane 14.0
2021-02-07 Revert "Propagate CTE property flags when copying a CTE list into a rule." Tom Lane 14.0
2021-02-07 Propagate CTE property flags when copying a CTE list into a rule. Tom Lane 14.0
2021-02-01 SEARCH and CYCLE clauses Peter Eisentraut 14.0
2020-11-19 Remove undocumented IS [NOT] OF syntax. Tom Lane 14.0
2020-11-19 Hash support for row types Peter Eisentraut 14.0
2020-11-18 Add more tests for hashing and hash-based plans Peter Eisentraut 14.0
2020-10-12 Adjust cycle detection examples and tests Peter Eisentraut 14.0