wrong generated sql query order
| От | Miha Radej |
|---|---|
| Тема | wrong generated sql query order |
| Дата | |
| Msg-id | 4308E160.6010309@siix.com обсуждение исходный текст |
| Ответы |
Re: wrong generated sql query order
|
| Список | pgadmin-support |
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
В списке pgadmin-support по дате отправления: