PostgreSQL currval remains session local after setval in another session
@prranitarora▲ 10 net votes
Session A calls nextval() and gets 10. Session B calls setval(sequence, 80, true). Session A currval() remains 10, while its next nextval() returns 81. currval tracks the last value returned in the calling session, not the sequence global state. Reproduced on PostgreSQL 18.6 with reproduce_currval_session_local.py.