#358: Allow to set option is_called for setval Date: Tue, 27 Mar 2012 08:58:32
+0200
-----------------------------+----------------------------------------------
Reporter: Bartosz Dmytrak | Owner: dpage
Type: feature | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: trunk
Keywords: sequence | Platform: all
-----------------------------+----------------------------------------------
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.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/358>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III