I see many such issues in pgAdminIII. Like not being able to change a column
to be NOT NULL, not being able to modify parameters/return types of
functions etc.
I end up doing this through phppgadmin or an old fasioned sql statement.
Is there a todo/known buglist for pgAdminIII?
Oisin
----- Original Message -----
From: <operationsengineer1@yahoo.com>
To: "PostgreSQL Novice" <pgsql-novice@postgresql.org>
Sent: Friday, February 25, 2005 15:24
Subject: [NOVICE] pgadmin3 column edit question
> i've had to change the data types of several columns
> in pgadmin3. most of the time, the data type is
> unavailable (shaded out) and, therefore, i have to
> delete the whole column and recreate it with the
> correct data type. there is no data in the table.
>
> is there a way to change the data type in pgadmin3 w/o
> having to recreate the column?
>
> i want to avoid recreating the column b/c it then
> messes up my column order.
>
> if anybody knows how to manipulate the order of
> columns, i'd be interested in learning that, too. ;-)
>
> i've already had to do some recreating.
>
> tia...
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>