SQLDelight/Postgresql: is there any way to set the...

# squarelibraries

[Tim Ortel]

SQLDelight/Postgresql: is there any way to set the transaction isolation level for a transaction?

[griffio]

😞 Sadly, unless someone else knows, the Transacter in JDBCDriver api doesn’t yet support setting the isolation level
The only escape hatch is to use driver.execute in a transaction block such as:

example.myQueries.transaction {
   driver.execute(null, "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE", 0)
   example.myQueries.update(123, "mychange")
}

[Tim Ortel]

Thank you that is actually pretty helpful. This way I could write extensions functions for each isolation level.

[Tim Ortel]

However I feel like this is something that should be supported by sqldelight.