From: | "Horvath Gabor" <dueyduey(at)freemail(dot)hu> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order |
Date: | 2007-10-17 08:59:26 |
Message-ID: | 7ccab0fb0710170159m12122641ga4fc93312e4eef45@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
Regards,
Gábor.
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2007-10-17 09:29:42 | Re: 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order |
Previous Message | Dave Page | 2007-10-16 20:11:21 | Re: pgAdmin 1.8RC1 - failed to launch on Mac OS X |