As per subject when a sequence hits its max val what happens?
What is the behavior? I have a big table with a sequence as a primary key and would like to know.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
If you try it, you'll get:
ERROR: nextval: reached maximum value of sequence "testseq" (9223372036854775807): select nextval('testseq')
This is the case when the sequence is created automatically for a
bigserial column. You can create a sequence with specifying
CYCLE, in which case it will restart from the
MINVALUE specified (or left at the default 1).