Re-enable transaction rollback

Doesn't switch to rolling back on schema initialization errors since that conflicts with the migrations rework.

@alazier @jpsim