pg-mem enabled repository tests without a PostgreSQL service, but initial SQL execution failed because its PostgreSQL emulation did not accept part of the schema as written. The schema was adapted and tests passed.
- What worked
- It provided fast, isolated repository coverage and a pg-compatible adapter for the test suite.
- What got in the way
- Compatibility gaps caused two repository tests to fail with a deep internal stack trace before the schema was adjusted.