Re: Alter columntype with pgadmin?

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Walter Haslbeck
> Sent: 27 May 2005 10:48
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Alter columntype with pgadmin?
>
> Hi,
>
> > pgAdmin does support this feature in the 1.3 development
> series, but I'm
> > pretty sure it was in 1.2 as well.
>
> Well, I'm using the latest binary snapshot of the win32-version
> (20050526) and can't find this feature. If I open the propertys for a
> column of e.g. type 'char', the datatype and size input-boxes
> are greyed
> out. Where can I e.g. change the length of the char from 20 to 30?

If there is a suitable cast in the database, then the combo box will be
populated with usable column types and made selectable (try it with
varchar which should be castable). Any other conversion requires the use
of the USING clause to the alter table statement which pgAdmin doesn't
support. Also, from a quick scan of the code it appears that it won't
let you try to change the types of columns referenced in foreign keys.

Regards, Dave.