Skip to content

Change Isolation level of a transaction in Reactive Postgres Client (Quarkus)

I want to execute some dql/dml queries in a transaction with the isolation level READ_UNCOMMITED. I’m using the reactive postgres client with mutiny with the suggested method withTransaction() from the Quarkus docs, but I couldn’t find any way to change the isolation lvl.

Is that possible, and if yes how can I achieve this ? Thx !

Answer

You can change the isolation level by executing a SQL query:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED