-- F-4 SEAM ROLLBACK — restores both seam views to inert WHERE-false form. -- Lossless and instantaneous (views project no stored data). -- Matches one-roof-phase1-test-mode-deferred-substrate-completion-2026-06-02/sql/sb2_views_ddl.sql.

\set ON_ERROR_STOP on BEGIN;

CREATE OR REPLACE VIEW v_governance_object_inventory AS SELECT NULL::text AS object_type, NULL::text AS object_ref, false AS requires_owner, false AS born WHERE false;

CREATE OR REPLACE VIEW v_governance_object_containment AS SELECT NULL::text AS object_type, NULL::text AS object_ref, NULL::text AS parent_type, NULL::text AS parent_ref WHERE false;

COMMENT ON VIEW v_governance_object_inventory IS NULL; COMMENT ON VIEW v_governance_object_containment IS NULL;

COMMIT;

SELECT 'seamA_inert' AS seam, count() AS rows FROM v_governance_object_inventory UNION ALL SELECT 'seamB_inert', count() FROM v_governance_object_containment;