From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Ivan <Ivan-Sun1(at)mail(dot)ru> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: alter table bug |
Date: | 2004-12-11 17:30:54 |
Message-ID: | 41BB2ECE.1030705@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Ivan wrote:
> Hello,
>
> I found a bug in PgAdminIII 1.2.0 (Nov 29 2004) for Win XP
>
> I open the table properties diaog,
> suppose that in a columns tab i have the
> column "description" of type text.
> I click remove button, then add a column
> with name "description" and type varchar,
> set the length of this fiels 256.
>
> When I open SQL tab i see folowing text
>
> ALTER TABLE test ADD COLUMN description varchar(256);
> ALTER TABLE test DROP COLUMN description;
>
> - changes are in wrong order!!!!
This results from the internal mechanism of dropped column detection. I
wonder if it's worth redesigning the stuff to avoid this quite rare
situations (which can be avoided easily by doing it in two steps).
> P.S. It would be great if snapshot page
> http://www.pgadmin.org/snapshots/win32
> works again.
see http://pgadmin.postgresql.org/snapshots/win32
There are quite some hosting problems a the moment.
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan | 2004-12-11 17:51:51 | Grant wizard for function privileges bug |
Previous Message | Andreas Pflug | 2004-12-11 17:11:28 | Re: Bug in a table properties dialog |