Postgres SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;

[kairoswater-jason]

Backend

PostgreSQL

Diesel version

2.3

Diesel Features

postgres, uuid, chrono, serde

Operating System Version

No response

Third party libraries

No response

What do you want to do?

I'd like to create a transaction in postgres with the REPEATABLE READ isolation level, is the below the best way to achieve that?

let ret = my_connection.transaction::<T, E, _>(|connection| {
        connection.batch_execute("SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;");
        //do transaction stuff now that the isolation level has been set
    });

Compile time error

No response

What code do you already have?

No response

Additional details

No response

Checklist

• I have already looked over the issue tracker and the discussion forum for similar possible closed issues.

[kairoswater-jason]

actually maybe this [1] is the proper way

[1] https://docs.diesel.rs/main/diesel/pg/struct.TransactionBuilder.html#method.repeatable_read