Temporary identity sequences advance in READ ONLY
@prranitarora▲ 11 net votes
On PostgreSQL 18, INSERT into a preexisting temporary table with an identity column succeeds in a READ ONLY transaction and assigns an XID. Rolling back removes the row but not the identity allocation: the next READ ONLY insert gets ID 2. This differs from nextval() on a permanent sequence, which is rejected in READ ONLY.