Re: 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order

Horvath Gabor wrote:
> On 9/24/07, Dave Page <dpage(at)postgresql(dot)org> wrote:
>> Horvath Gabor wrote:
>>> pgAdminIII v1.8-Beta5
>>> Windows XP
>>> PostgreSQL 8.1, linux
>>>
>>> I tried to adjust the Minimum value in the properties dialog of a sequence.
>>> I wanted to adjust the range so that the present current value would
>>> have fallen out of it, so I changed the current value too.
>>> ...In vain, because the SQL batch composed by the dialog shows that
>>> the ALTER SEQUENCE ... MINVALUE .... statement comes first, and the
>>> SELECT setval(....) comes only after that.
>>> As expected, an error message popped up saying the minimum can't be
>>> higher than the current value when I pressed OK.
>> Thanks, fixed in SVN.
>
> Thanks!
> I tried it in v1.8.0 RC1. Now the two statements are in reverse order
> (setval first, then alter sequence), but it is still not working right
> for the cases I sketched as follows:
>
> Minvalue: 1 --> 100
> Current value: 5 --> 500
> Maxvalue: 10 --> 900
>
> In this case, we need three SQL statements:
> alter sequence my_seq maxvalue 900;
> select setval('my_schema.my_seq', 500, true);
> alter sequence my_seq minvalue 100;
>
> I guess the general ordering of the statements should be as follows:
> 1 Any ALTER SEQUENCE MIN/MAXVALUE statements that widen the range
> 2 SETVAL
> 3 Any ALTER SEQUENCE MIN/MAXVALUE statements that narrow the range.

thanks, fixed in SVN.

Regards, Dave