nextval() on serial using old, existing value on insert? - Mailing list pgsql-admin

From Wells Oliver
Subject nextval() on serial using old, existing value on insert?
Date
Msg-id CAOC+FBWAzy8MDbwE2XJGsi8eV=QCuSS8orgAEdyOLr37_Z4ByQ@mail.gmail.com
Whole thread Raw
Responses Re: nextval() on serial using old, existing value on insert?
Re: nextval() on serial using old, existing value on insert?
List pgsql-admin
I have a simple table with a given column defined like so:

 common_key    | integer |           | not null | nextval('alias.identity_common_key_seq'::regclass)  | plain


Very very very infrequently, on an INSERT where this column is not specified, this column will be assigned a value that already exists in the table, versus the next presumably unused value in the sequence. I cannot figure this out. Is there any reason why this might be the case?

--

pgsql-admin by date:

Previous
From: James Fraley
Date:
Subject: Re: Index recreation details with REINDEX TABLE CONCURRENTLY
Next
From: Keith
Date:
Subject: Re: nextval() on serial using old, existing value on insert?