Miha Radej wrote:
in the table properties pane, tab "columns" i then remove col2 and
immediately add another column, by the name of col2 and type text and
pgadmin produces the following queries:
ALTER TABLE sampletable ADD COLUMN col2 text;
ALTER TABLE sampletable DROP COLUMN col2;
This i
hi!
this happens to me on any table i've tried. here is a sample:
CREATE TABLE sampletable
(
col1 serial NOT NULL,
col2 int4
)
WITH OIDS;
ALTER TABLE sampletable OWNER TO adocuments;
this is a table in a "adocuments" schema, owned by the user "adocuments".
in the table properties pane, tab
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 AD
