Postgres Pro
Downloads
Home   >   mailing lists

feature request - allow to set option is_called for setval - Mailing list pgadmin-support

From Bartosz Dmytrak
Subject feature request - allow to set option is_called for setval
Date
Msg-id CAD8_Ucbfa9kNK=MPrzac0eyr-iDKo7q5-0Xtqy4tD_Ot12p=Xw@mail.gmail.com
Whole thread Raw
Responses Re: feature request - allow to set option is_called for setval  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
Tree view
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. 
 "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.

thanks & regards,
Bartek

pgadmin-support by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: PostgreSQL 8.1 Error: Server doesn't listen
Next
From: Colin Beckingham
Date:
Subject: Constraint column missing from properties?