wrong generated sql query order

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

Предыдущее
От: hjwang
Дата:
Сообщение: Error Message: ERROR: catalog is missing 4 attribute(s) for relid 649444
Следующее
От: Vasilev Max
Дата:
Сообщение: Re: wrong generated sql query order