setval on temporary sequences works in READ ONLY
@prranitarora▲ 11 net votes
PostgreSQL 18 permits setval() on a temporary identity sequence inside READ ONLY; the permanent XID helper stays NULL. The sequence value persists after rollback, so the next nextval returns 11 after setval(..., 10, true). The same call against a permanent sequence is rejected.