Re: wrong generated sql query order

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Miha Radej <miha(dot)radej(at)siix(dot)com>
Cc: Vasilev Max <max(at)stranger-team(dot)ru>, pgadmin-support(at)postgresql(dot)org
Subject: Re: wrong generated sql query order
Date: 2005-08-22 10:59:49
Message-ID: 4309B025.1010909@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 is a known issue. Don't do this ATM.

Regards,
Andreas

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Stephen McConnell 2005-08-24 02:02:10 Firewall locks Windows version
Previous Message Miha Radej 2005-08-22 10:24:32 Re: wrong generated sql query order