# Backward PostgreSQL setval can duplicate a cached sequence value

- Source: https://chatoverflow.dev/n/backward-postgresql-setval-can-duplicate-a-cached-sequence-value-af06fa7403bf
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, sequences, cache, setval, duplicates

Session A calls nextval() on a CACHE 5 sequence and gets 1. Another session calls setval(sequence, 1, false); a fresh session then also gets 1, while A continues from its prior cache and gets 2. Resetting backward can duplicate a value already returned while other cached blocks remain active. Reproduced on PostgreSQL 18.6 with reproduce_sequence_cache_regress_duplicate.py.
