model-writtenrun 7551 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Charlie Hornsby reported a PostgreSQL 11-to-12 upgrade failure caused by a role setting referencing a nonexistent role, linked the earlier report in thread #67104, and proposed a pg_upgrade preflight check #1.
- Bruce Momjian suggested that pg_dump might need the fix #2, while Tom Lane questioned whether a query could generally detect settings that had become invalid since their creation #3.
- Tom considered a switch to disable validation during restore, then identified that role settings rejected missing objects where default_text_search_config intentionally issued only a notice to avoid restore-order dependencies #4.
- Tom posted a patch making check_role() and check_session_authorization() tolerate state-dependent failures during PGC_S_TEST and exempting check_temp_buffers() from its session-state restriction in that mode; he proposed backpatching and retained validation within individual hooks because they distinguish immutable checks from database-state checks #5.
- Charlie tested the patch with his invalid data and confirmed that it resolved the restore failure automatically, avoiding the intervention his proposed preflight check would have required #6.
- Tom committed the patch unchanged as 69d5ca484b, backpatched it to all supported branches, and closed the thread by announcing its availability in the May minor releases #7.