Ticket #358 (new feature)

Opened 14 months ago

Last modified 14 months ago

Allow to set option is_called for setval

Reported by: Bartosz Dmytrak Owned by: dpage
Priority: minor Milestone:
Component: pgadmin Version: trunk
Keywords: sequence Cc:
Platform: all

Description

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.

Change History

Changed 14 months ago by gleu

  • summary changed from Allow to set option is_called for setval Date: Tue, 27 Mar 2012 08:58:32 +0200 to Allow to set option is_called for setval
Note: See TracTickets for help on using tickets.