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

From: Dave Page <dpage(at)postgresql(dot)org>
To: Horvath Gabor <dueyduey(at)freemail(dot)hu>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order
Date: 2007-09-24 08:04:11
Message-ID: 46F76F7B.3060701@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Pascal Van Puymbroeck 2007-09-25 19:31:22 Bug report
Previous Message Dave Page 2007-09-23 10:20:44 Re: Weird characters saved in SQL file