pg-teardown-rollback-before-delete

Summary

When a test fails partway through a database transaction, the connection can be left in a broken state where no further SQL commands will work. The pg_api fixture handles this by issuing a rollback before attempting to delete test data, ensuring that cleanup always succeeds even after test failures — without this, one broken test could cause a cascade of failures in subsequent tests sharing the same connection.