Ensure test runs in a single transaction

This is to be able to set the session variable client_min_messages
which is otherwise reset by pg_bouncer (when running in that context)