Re: feature request - allow to set option is_called for setval

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
Cc: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: feature request - allow to set option is_called for setval
Date: 2012-03-29 19:44:09
Message-ID: 1333050249.2335.6.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-03-29 19:45:19 Re: Constraint column missing from properties?
Previous Message Guillaume Lelarge 2012-03-28 21:54:33 Re: 1.15 Dev with wxwidgets 2.9.3