Syntax for setting transaction isolation level

[vieks]

I don't see it in the doc how to set isolation level for transactions ?

Thx.

[elhigu]

As far as I know there is no way to do it without knex.raw().

[vieks]

Why not implement it as a parameter for the transaction method ? It will be a quick and more elegant way than doing a raw call.

Like Sequalize do: http://docs.sequelizejs.com/en/latest/docs/transactions/#isolation-levels

[elhigu]

Something like that sounds reasonable, exact syntax needs to be discussed though. When it is clear what is wanted, someone might implement it too :) Do you have some clear vision how it would exactly work with knex syntax to get discussion started?

[carera]

+1 for this
For now, can someone tell me how would i approach this with knex.raw(), please?

[jmurzy]

This is a dupe of #581.

@carera You must have figured it out by now but the current "workaround" for Posgres is in #581. A bit more hackier but I believe you could do the same for MySQL as well.

[elhigu]

@jmurzy thanks! Closing this one...