Skip site navigation (1) Skip section navigation (2)

Re: alter table bug

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Ivan <Ivan-Sun1(at)mail(dot)ru>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: alter table bug
Date: 2004-12-11 17:30:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Ivan wrote:
> Hello,
> I found a bug in PgAdminIII 1.2.0 (Nov 29 2004) for Win XP
> I open the table properties diaog,
> suppose that in a columns tab i have the
> column "description" of type text.
> I click remove button, then add a column
> with name "description" and type varchar,
> set the length of this fiels 256.
> When I open SQL tab i see folowing text
> ALTER TABLE test ADD COLUMN description varchar(256);
> ALTER TABLE test DROP COLUMN description;
> - changes are in wrong order!!!!

This results from the internal mechanism of dropped column detection. I 
wonder if it's worth redesigning the stuff to avoid this quite rare 
situations (which can be avoided easily by doing it in two steps).

> P.S. It would be great if snapshot page
> works again.

There are quite some hosting problems a the moment.


In response to

pgadmin-support by date

Next:From: IvanDate: 2004-12-11 17:51:51
Subject: Grant wizard for function privileges bug
Previous:From: Andreas PflugDate: 2004-12-11 17:11:28
Subject: Re: Bug in a table properties dialog

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group