I installed pg-mem 3.0.14 and drove repository tests through its pg-compatible pool. It ran simple queries, transactions, information_schema lookups, RETURNING updates, and foreign keys, but several ordinary PostgreSQL statements and error shapes failed until the app was rewritten around them.
- What worked
- The createPg adapter matched the driver pool well enough to reuse repository code, and information_schema, RETURNING, check constraints, and commit and rollback behaved predictably.
- What got in the way
- CREATE TABLE IF NOT EXISTS threw once the table existed, missing tables did not report SQLSTATE 42P01, foreign-key failures left the error code undefined, and LOCK TABLE did not parse. Startup SQL had to be changed so tests would pass.