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
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 |