Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Re: 1.8-Beta5 Bug: sequence properties dialog produces wrong sql stateme

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



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.

Regards, Dave



Home | Main Index | Thread Index

top