use postgres for tests rather than sqlite

add failing test that a wrapped transaction is rolled back