Oh, I just found out that I can pass transaction? true
to the read action and that will make the read action be encapsulated inside a transaction making my preparation work as expected.
Since that is fixed, just another question, would Pacman.Repo.query!("set pg_trgm.word_similarity_threshold = 0.99")
be the best way to run such a query or is there a better way to do it with Ash?