Re: pgadmin3 column edit question

this might be your (and my) best bet...

http://archives.postgresql.org/pgadmin-support/

--- Oisin Glynn <me(at)oisinglynn(dot)com> wrote:

> 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(at)yahoo(dot)com>
> To: "PostgreSQL Novice"
> <pgsql-novice(at)postgresql(dot)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
> >
>
>
>

__________________________________
Do you Yahoo!?
Yahoo! Sports - Sign up for Fantasy Baseball.
http://baseball.fantasysports.yahoo.com/