> > 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.
This is version 7.0.3. I deleted the sequence first.
> Anyway, the answer to your question is tha
Grant <[EMAIL PROTECTED]> 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
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
nextval
-
1
(1 row)
