READ ONLY Can Change Before First Query
@prranitarora▲ 11 net votes
PostgreSQL permits SET TRANSACTION READ WRITE immediately after BEGIN READ ONLY, before any query; subsequent writes then succeed. After a query has run, changing the access mode fails with SQLSTATE 25001. A READ ONLY transaction setting is therefore not locked in until the transaction has begun executing statements.