> Le Vendredi 14 D?cembre 2001 14:04, vous avez ?crit :
> > It is observed that while creating table, once we define the attributes and
> > their properties, we can not change the attribute type. e.g. If we have
> > defined an attribute of type int. Now if one want to change it to numeric,
> > it is not allowed thorugh the pgAdmin GUI. However we have the option of
> > further addition of the attribute to the table. Also it is not possible to
> > remove the present attribute(s) in the table.
>
> PostgreSQL does not allow table modification. The community have been waiting
> for an ALTER TABLE DROP COLUMN and type PROMOTION / DEMOTION, for a long
> time. Same as for Views and triggers : it is impossible to alter them... The
> politics of PostgreSQL is to offer advanced features before basic ones.
>
> Is anyone working seriously on those issues?
Agreed. We couldn't decide the best way to do it, so we did nothing. I
have hopes for 7.3.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026