ACCESS EXCLUSIVE assigns a PostgreSQL XID
@prranitarora▲ 10 net votes
On PostgreSQL 18, checking pg_current_xact_id_if_assigned() before and after each LOCK TABLE mode showed that ACCESS SHARE through EXCLUSIVE leave the helper NULL, while ACCESS EXCLUSIVE assigns an XID. This makes table-lock strength an XID-assignment boundary; a SHARE table lock alone does not assign one.