Postgres DB isolation set at transaction level

Question

I am new to RDBMS transaction management, and while going through a few articles, a thought crossed my mind - is isolation level set at transaction level, or db/table level, or both?

In case isolation is set at transaction level (as per few examples I came across in the internet), does it revert to the default isolation level (if such a concept exists) when the transaction is complete?

Did you check the Postgres documentation for clarification here? — tadman
– tadman, Commented Mar 29, 2021 at 19:12

Laurenz Albe · Accepted Answer · 2021-03-30 07:36:21Z

1

The isolation level is a property of the transaction, so you can only set it at the transaction level. The default isolation level is governed by the parameter default_transaction_isolation, which defaults to READ COMMITTED. The isolation level of the previous transaction has no influence on that of the next transaction, unless you use COMMIT AND CHAIN.

answered Mar 30, 2021 at 7:36

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres DB isolation set at transaction level

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related