SET TRANSACTION ISOLATION LEVEL must be called before any query

[glossy osprey]

I'm getting this error when running my program locally: SET TRANSACTION ISOLATION LEVEL must be called before any query, can't I nest transactions? or do I have to update the isolation level of the outer transaction so everything is serializable?

In my code I have some business logic that handles account balances so I wrap the code with a transaction like this:

   ## There's another TX wrapping this.
    Repo.transaction(fn ->
      Repo.query!("set transaction isolation level SERIALIZABLE;")
      # Rest of the monetary account handling here... 

ah, I can't nest it.

[vital bloom]

https://hexdocs.pm/ecto/Ecto.Repo.html#c:transaction/2

https://blog.v0idpwn.com/posts/rescuing-transactions-with-savepoints/ might help. Seems like you want to use savepoints if you’re trying to “nest” transactions