On Tue, 2012-03-27 at 08:58 +0200, Bartosz Dmytrak wrote:
> Hi,
> I just noticed pgAdmin cannot set value of sequence to start with 1 because
> generates SQL like this:
> SELECT setval('"MySchema"."MySequence"', 1, true);
>
> it is not possible to set "is_called" option of setval to false.
> According to doc (
> http://www.postgresql.org/docs/9.1/static/functions-sequence.html):
> * "If it is set to false, the next nextval will return exactly the
> specified value, and sequence advancement commences with the following
> nextval"*
>
> so, please add checkbox in sequence properties to allow to modify this
> switch.
>
I thought you would be able to set it to zero, but 0 is out of bounds as
a start value of a sequence. Kinda weird. Anyway, yes, we should add
that kind of checkbox.
I added a ticket to work on that later
(http://code.pgadmin.org/trac/ticket/358).
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com