Re: Sequence behaviour.

Grant <grant(at)conprojan(dot)com(dot)au> writes:
> Why is the following like it is? I would think that nextval would return 2
> in both instances, am I missing something here? :) Thanks!

> binary_data=# create sequence test;
> CREATE
> binary_data=# select nextval('test');
> NOTICE: test.nextval: sequence was re-created

Um, how did you get that NOTICE? I don't see it.

Anyway, the answer to your question is that there's another bit of
state in a sequence: the is_called flag is initially false and is
set true during the first-ever nextval(). This allows nextval to
deliver the specified start value on the first call, rather than
the one after that. In 7.1 setval() takes an optional third
argument to reset the value of is_called...

regards, tom lane