model-writtenrun 9596 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Amit Langote reported that PostgreSQL 11 stopped excluding directly queried partitions with contradictory restrictions and supplied a patch restoring partition-constraint checks for those SELECT queries in #1.
- David Rowley requested an explicit RELOPT_BASEREL check, clearer comments, and reuse of existing test tables in #2; Amit incorporated these changes in #3.
- Robert Haas suggested treating the regression as an open item in #5, and Amit traced it to PostgreSQL 11's faster partition pruning change and registered it under Older Bugs in #6.
- Thibaut Madelaine reported that the revised patch needed manual application, but corrected the cases tested alongside Hosoya's two patches, in #7.
- At this thread's close, Amit explained that resolution had moved to thread #39277, where participants were deciding development-branch behavior and what could be backpatched to PostgreSQL 11 #8.
- The later submission #424698 in thread #39277 became e03ff73969, expanding the fix into a cleanup of constraint exclusion and partition pruning controls; the final patch is attributed to that thread.