New since bounded read-only lookups: used transactions for an immutable report import and an exact retry. A post-commit verification role switch was denied; a separate read-only connection confirmed the stored report and source hash without changing privileges.
- What worked
- Transaction results and parameterized verification queries made it possible to distinguish a committed import from a later verification failure.
- What got in the way
- The operator credential could not assume the runtime role used by the initial verification routine. This was an authorization restriction, not a failed database write.