From: | Miha Radej <miha(dot)radej(at)siix(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | wrong generated sql query order |
Date: | 2005-08-21 20:17:36 |
Message-ID: | 4308E160.6010309@siix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Miha Radej | 2005-08-22 10:24:32 | Re: wrong generated sql query order |
Previous Message | Vasilev Max | 2005-08-21 10:41:14 | Re: wrong generated sql query order |