Can't setval() a sequence to return the first value

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Can't setval() a sequence to return the first value
Дата
Msg-id 50E5692A.7050309@2ndQuadrant.com
обсуждение исходный текст
Ответы Re: Can't setval() a sequence to return the first value  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
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





В списке pgsql-hackers по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Behaviour of bgworker with SIGHUP
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Can't setval() a sequence to return the first value