-- ============================================================================ -- F_prod_03 — PRODUCTION SEED ROLLBACK (REVERSAL LEVER) -- Target DB: directus (PRODUCTION) -- Undoes ONLY the F_prod_01 seed (by its provenance tag). gap returns to 210. -- ============================================================================ \set ON_ERROR_STOP on \pset pager off

\echo ====================ENTRY==================== SELECT (SELECT count() FROM governance_object_ownership WHERE created_by='F6_OWNERSHIP_SEED_COMMIT') AS seed_rows, (SELECT count() FROM v_object_owner_gap) AS gap_before;

BEGIN; DELETE FROM governance_object_ownership WHERE created_by='F6_OWNERSHIP_SEED_COMMIT'; DO $$ DECLARE v_own int; v_gap int; BEGIN SELECT count() INTO v_own FROM governance_object_ownership WHERE created_by='F6_OWNERSHIP_SEED_COMMIT'; SELECT count() INTO v_gap FROM v_object_owner_gap; IF v_own <> 0 THEN RAISE EXCEPTION 'ROLLBACK INCOMPLETE: seed rows=% (expected 0).', v_own; END IF; IF v_gap <> 210 THEN RAISE EXCEPTION 'GAP NOT RESTORED: gap=% (expected 210).', v_gap; END IF; RAISE NOTICE 'ROLLBACK OK: seed removed, gap restored to 210.'; END $$; COMMIT;

\echo ====================POST==================== SELECT (SELECT count() FROM governance_object_ownership WHERE created_by='F6_OWNERSHIP_SEED_COMMIT') AS seed_rows, (SELECT count() FROM v_object_owner_gap) AS gap_after; \echo ====================DONE====================