model-writtenrun 4956 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Gilles Darold reported that pg_dump before PostgreSQL 15 could block on locked partitioned tables even when excluded with -T, because getTables() called partition metadata functions before applying exclusions, and asked whether to add filtering or backport the existing fix #1.
- Tom Lane favored backporting the complete existing fix, which he considered sufficiently mature, because a narrower solution would only partially address the problem; Gilles volunteered to prepare it #2 #3.
- Gilles submitted adaptations for PostgreSQL 11–14 and reported that pg_dump TAP regression tests passed on every version; the patches defer partition metadata extraction and typed-table name formatting until later dump processing #4.
- Tom committed the submitted backports for PostgreSQL 14, 13, and 12 with small memory-cleanup, comment, and formatting edits, and the PostgreSQL 11 version with additional local variable and result-access cleanup #4 55f30e6c76 e46e986bae 344b784920 b1f106420b.
- Tom also found and backported a related fix that filters policy queries server-side before evaluating expressions on tables, producing the PostgreSQL 11–14 policy commits without another attached patchset #5 b7333e8269 1ed6f1b911 a5b26aaafe 03ac485494.
- The thread ends with Tom confirming review and completion of both backport groups, with no submitted work left pending #5.