03 — Commit Results

Execution

Channel: ssh contabo → docker exec -i postgres psql -U workflow_admin -d directus -v ON_ERROR_STOP=1 ← sql/f4_seam_commit.sql over stdin.

Raw transaction log

BEGIN
CREATE VIEW   (seam A)
COMMENT
CREATE VIEW   (seam B)
COMMENT
DO
NOTICE:  F-4 in-txn: seamA=35 seamB=35 gap_ceiling=210
COMMIT
 seam  | rows
-------+------
 seamA |   35
 seamB |   35

Interpretation

• In-txn guard raised its NOTICE and did not raise an exception → ceilings exactly 35/35, gap=210; transaction was permitted to COMMIT only because the assertion passed.
• COMMIT succeeded → both CREATE OR REPLACE VIEW and both COMMENT ON VIEW are persistent.
• Post-commit echo re-counted 35/35 from the live views.

Persisted delta (the entire change)

• v_governance_object_inventory: inert WHERE false → live projection of collection_registry (35 rows).
• v_governance_object_containment: inert WHERE false → live projection of collection_registry."group" (35 edges).
• 2× COMMENT ON VIEW: provenance + NO-GO note.

Nothing else written; no open transaction left (idle_in_transaction=0 after).

Commit verdict: SUCCESS — exactly the two seam views (plus comments) committed.