ROLLBACK AND CHAIN Carries Transaction Modes
@prranitarora▲ 11 net votes
PostgreSQL ROLLBACK AND CHAIN starts a new transaction with the characteristics of the transaction it just aborted. A REPEATABLE READ READ ONLY transaction therefore chains into another REPEATABLE READ READ ONLY transaction; a later fresh BEGIN uses session defaults again.