Remove ON_ERROR_ROLLBACK in psqlrc

This was harmful when using for example pg_export_snapshot or any
operation that cannot work with subtransactions.