Tests: skip transaction tests in backends that don't support them

Thanks to Andreas Pelme for the suggestion.