GPT Review — B3-F1b Execution Prompt + B3-F1c Automation Note — Approved with Patches — 2026-05-13

Scope reviewed

Reviewed Opus artifacts:

• knowledge/dev/laws/dieu44-trien-khai/prompts/p3d-birth-system-b3f1b-soft-gate-execution-prompt-DRAFT.md
• knowledge/dev/laws/dieu44-trien-khai/design/p3d-birth-system-b3f1c-full-scan-automation-note.md

Related GPT review:

• knowledge/dev/laws/dieu44-trien-khai/reviews/gpt-review-b3f1a-recompiled-sql-rev3-approved-with-automation-caveat-2026-05-13.md

Verdict

Status: APPROVED_FOR_AGENT_B3F1B_EXECUTION_WITH_GPT_PATCHES

B3-F1b execution prompt is approved after GPT patches. B3-F1c automation note is accepted as a design note, with shape-probe-first caveat.

GPT patches applied

Patch 1 — remove hardcoded sibling count/list in execution prompt

Changed dependency check from:

Live sibling trigger usage = exactly approved 3 collections

to policy-driven wording:

Live sibling trigger usage must match the sibling policy loaded from dot_config, with out_of_scope_sibling_count=0. Do not embed or assume a fixed sibling collection list; derive the approved set from policy.birth_trigger.accepted_sibling_scope.

Patch 2 — add sibling policy key to scope constants

Added:

sibling_policy_key = policy.birth_trigger.accepted_sibling_scope

Patch 3 — forbid runtime SQL modification

Prompt now says Agent must execute only reviewed rev3 SQL and must not regenerate, rewrite, optimize, or modify the reviewed SQL during execution.

Patch 4 — advisory lock boolean must be checked

Changed advisory lock statement to expose got_lock and require LOCK_BUSY if false.

Patch 5 — final fields expanded

Added:

• sibling_scope_derived_from_dotconfig=true|false
• out_of_scope_sibling_count=0
• reviewed_sql_executed_without_modification=true|false

Patch 6 — B3-F1c pg_cron caveat

B3-F1c note no longer recommends pg_cron without verification. It now requires SHAPE_PROBE_FIRST: use pg_cron only if live read-only probe confirms extension availability/operation; otherwise evaluate existing system_health_checks scheduler or fallback through separate design.

Approved B3-F1b execution scope

Agent may execute only:

1. CREATE FUNCTION public.fn_b3f1_log_collection_onboarding_gap(text,text,text,text) from reviewed rev3 artifact.
2. CREATE FUNCTION public.fn_collection_onboarding_soft_gate() from reviewed rev3 artifact.
3. CREATE TRIGGER trg_collection_onboarding_soft_gate ... from reviewed rev3 artifact.

Still forbidden

• No CREATE OR REPLACE.
• No COMMENT ON.
• No ALTER.
• No unreviewed SQL.
• No DML smoke test.
• No system_issues/system_health_checks DML.
• No hard gate.
• No Phase 5C2.
• No UI cutover.

Required Agent report

Agent must write:

• knowledge/dev/laws/dieu44-trien-khai/reports/p3d-birth-system-b3f1b-soft-gate-execution-report.md

Automation caveat remains

B3-F1b installs a real-time soft gate for collection_registry mutations. It does not fully automate drift detection for direct PG DDL drift. B3-F1c/B3-HC full-scan automation remains required before declaring B3-F fully automatic at scale.

Governance status

b3f1b_prompt_review_status=APPROVED_FOR_AGENT_B3F1B_EXECUTION_WITH_GPT_PATCHES
b3f1b_execution_allowed=true
b3f1c_automation_design_allowed=true_after_b3f1b_review
b3f1c_execution_allowed=false
hard_gate_allowed=false
phase5c2_migration_allowed=false
next_recommended_action=AGENT_EXECUTE_B3F1B_SOFT_GATE_WITH_REV6_OR_LATEST