Allow setting transaction isolation level
Closed this issue · 4 comments
phiresky commented
hediet commented
You mean by using [SET TRANSACTION](using https://www.postgresql.org/docs/9.1/static/sql-set-transaction.html)?
phiresky commented
Yeah like
```
BEGIN;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SELECT bla;
COMMIT;
```
2017-06-04 22:14 GMT+02:00 Henning Dieterichs <notifications@github.com>:
… You mean by using [SET TRANSACTION](using
https://www.postgresql.org/docs/9.1/static/sql-set-transaction.html)?
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or mute the thread.
phiresky commented
no actually like this
START TRANSACTION ISOLATION LEVEL SERIALIZABLE
2017-06-04 22:18 GMT+02:00 phire skyde <phireskyde@gmail.com>:
… Yeah like
```
BEGIN;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SELECT bla;
COMMIT;
```
2017-06-04 22:14 GMT+02:00 Henning Dieterichs ***@***.***>:
> You mean by using [SET TRANSACTION](using
> https://www.postgresql.org/docs/9.1/static/sql-set-transaction.html)?
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub, or mute the thread.
hediet commented
Now, transaction has two overloadings:
dbCon.transaction({ isolationLevel: IsolationLevel.Serializable }, async q => { ... });
dbCon.transaction(async q => { ... });