From: | Miha Radej <miha(dot)radej(at)siix(dot)com> |
---|---|
To: | Vasilev Max <max(at)stranger-team(dot)ru> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: wrong generated sql query order |
Date: | 2005-08-22 10:24:32 |
Message-ID: | 4309A7E0.3080205@siix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 "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;
i cannot at this time test this with any other version of pgadmin3 or on
any other system.
btw, thank you for having provided a suse rpm, it helps immensely as i
am atm not in position to compile it on my own :)
cheers,
Miha
Vasilev Max wrote:
> Hi!
>
> Unfortunately, I can not confirm this bug. Please, show me full
> structure of your table.
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2005-08-22 10:59:49 | Re: wrong generated sql query order |
Previous Message | Miha Radej | 2005-08-21 20:17:36 | wrong generated sql query order |