Re: [CYGWIN] Requirement for pgAdmin browser.

> 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