model-writtenrun 343 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Ayush Tiwari reported that concurrent DROP TABLESPACE could miss a newly recorded dependency and submitted two patches: an exclusive lock before checking dependencies, plus shared locks before four catalog-update paths to prevent the resulting deadlocks, with isolation tests for both problems #1.
- Andrew Dunstan confirmed the deadlock analysis, tested that GRANT and ALTER OWNER already followed the required locking protocol, and recommended squashing the fixes and backpatching all live branches #2.
- Ayush combined the two patches into one without changing the code or tests and agreed to backpatching #3.
- Michael Paquier supported backpatching and the locking approach while explicitly noting that he had not examined the details; Andrew confirmed he would handle the commit #4 #5.
- Andrew committed the combined patch with only comment formatting and commit-message edits as a12600b762, with backports through PostgreSQL 14, and announced that it was pushed; no outstanding work remained in the thread #3 #6.