Hello
postgres=# select setval('xx', 1, false);setval
-------- 1
(1 row)
postgres=# select nextval('xx');nextval
--------- 1
(1 row)
Regards
Pavel
2013/1/3 Hannu Krosing <hannu@2ndquadrant.com>:
> Hi hackers.
>
> Is it by design that you can't setval(seq, value) a sequence to a value
> which returns the first value:
>
> See the sample below for better explanation:
>
> hannu=# create sequence s;
> CREATE SEQUENCE
> hannu=# select nextval('s');
> nextval
> ---------
> 1
> (1 row)
> hannu=# select setval('s',1);
> setval
> --------
> 1
> (1 row)
> hannu=# select nextval('s');
> nextval
> ---------
> 2
> (1 row)
> hannu=# select setval('s',0);
> ERROR: setval: value 0 is out of bounds for sequence "s"
> (1..9223372036854775807)
>
> Should it not be possible to set sequence to one below the start value so
> that you can completely reset it ?
>
> --------------------
> Hannu
>
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers