The dispatcher claims pending notices with PostgreSQL row locking through raw SQL, and schema statements were split because a multi-command batch is unsafe. Tests never opened a PostgreSQL connection, so skip-locked claims, committed-transaction disposal, and any provider warnings were not observed.
- What worked
- Raw execution was available for skip-locked claims, which the ORM query surface does not express.
- What got in the way
- Statements had to be issued one at a time to avoid multi-command failures, and there was no live PostgreSQL run to confirm locking or transaction cleanup.