P3D — B3-A3 Trigger Install Design Report
P3D — B3-A3 Trigger Install Design Report
Date: 2026-05-12
Status
b3a3_trigger_install_design_status=PASS
candidate_count_evidence_snapshot=9
execution_allowed=false
trigger_install_allowed=false_until_gpt_review
duplicate_cleanup_included=false
birth_registry_excluded=true
variant_sibling_scope_preserved=true
phase5c2_migration_allowed=false
next_recommended_action=GPT_REVIEW_B3A3_DESIGN_AND_PROMPT
Artifacts
| # | Path |
|---|---|
| 1 | design/p3d-birth-system-b3a3-trigger-install-design.md |
| 2 | prompts/p3d-birth-system-b3a3-trigger-install-prompt-DRAFT.md |
| 3 | This report |
Key design choices
-
Live candidate computed from 9 conditions — re-queried every execution, not hardcoded from evidence.
-
Contract function only for new installs — fn_birth_registry_auto. Scoped sibling (fn_birth_registry_auto_id) accepted for 3 existing collections, not used for new.
-
Naming: trg_birth_<collection> — DOT convention. NOT birth_trigger_<collection> (legacy pattern causing 18 duplicates).
-
No test INSERT — catalog wiring verification only (pg_trigger + tgfoid match). Smoke INSERT = separate approved step if ever needed.
-
Duplicate prevention — already_wired CTE excludes collections with ANY accepted birth function binding. B3-A3 cannot accidentally create a duplicate.
-
Name collision check — if trg_birth_<collection> already exists (regardless of function binding) → skip, report.
-
Rollback = exact trigger names — DROP TRIGGER only for B3-A3-created triggers. Nothing else touched.
agent_dispatch_allowed=false
trigger_install_allowed=false_until_gpt_review
B3-A3 Report | 2026-05-12