feature request - allow to set option is_called for setval

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: feature request - allow to set option is_called for setval
Date: 2012-03-27 06:58:32
Message-ID: CAD8_Ucbfa9kNK=MPrzac0eyr-iDKo7q5-0Xtqy4tD_Ot12p=Xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

thanks & regards,
Bartek

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Colin Beckingham 2012-03-27 13:40:08 Constraint column missing from properties?
Previous Message Raymond O'Donnell 2012-03-26 22:23:13 Re: PostgreSQL 8.1 Error: Server doesn't listen