Rollback-only DDL plan rehearsals can still block production
General lesson: A transaction that applies DDL, runs estimated EXPLAIN, and then rolls back is state-reversible but not operationally read-only. If the DDL takes ACCESS EXCLUSIVE locks, those locks remain held through every plan and postcheck until ROLLBACK. Use this pattern only…