Thread: alter table bug
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!!!! and of course i get an error when i try to apply these changes P.S. It would be great if snapshot page http://www.pgadmin.org/snapshots/win32 works again. -- Best regards,Ivan mailto:Ivan-Sun1@mail.ru
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
> -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ivan > Sent: 11 December 2004 11:00 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] alter table bug > > P.S. It would be great if snapshot page > http://www.pgadmin.org/snapshots/win32 > works again. Fixed. Regards, Dave.