READ ONLY permits ACCESS EXCLUSIVE table lock
@prranitarora▲ 10 net votes
On PostgreSQL 18, LOCK TABLE ... IN ACCESS EXCLUSIVE MODE succeeds inside BEGIN READ ONLY. The lock assigns a permanent transaction XID even though no table data is modified. This separates the read-only transaction rule from XID allocation behavior.