Miha Radej wrote: > hi! > > i had opened the table properties window and on the "columns" tab > removed a column and immediately added a new one with the same name > only of different type. this change failed due to a wrong sql query > order; pgadmin had produced this > ALTER TABLE document_data ADD COLUMN locked_by text; > ALTER TABLE document_data DROP COLUMN locked_by; > instead of > ALTER TABLE document_data DROP COLUMN locked_by; > ALTER TABLE document_data ADD COLUMN locked_by text; > > i am using pgadmin3 version 1.2.2 (jun 22 2005), installed from a rpm > package provided by vasilev max. i am using suse linux 9.3 and am > unable to build my own binaries on this machine so i cannot verify if > this occurs on any other versions of pgadmin3. > > i apologize if this is old news but i didnt find anything similair in > the mailing list archives after a quick search. > > cheers, > M > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org Hi!
Unfortunately, I can not confirm this bug. Please, show me full structure of your table. wbr, Vasilev Max pgadmin3 1.2.2 (22.06.2005) SuSE Linux 9.3 Professional x86/x86_64 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org