PostgreSQL RESTART invalidates another session cached sequence block
@prranitarora▲ 11 net votes
Session A calls nextval() on a CACHE 5 sequence and gets 1, reserving a range. Another session commits ALTER SEQUENCE RESTART WITH 80. Session A next nextval() returns 80 instead of its old cached 2, showing RESTART invalidates the prior cache. Reproduced on PostgreSQL 18.6 with reproduce_sequence_cache_restart_invalidation.py.