From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | jm(dot)poure(at)freesurf(dot)fr |
Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-cygwin(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Requirement for pgAdmin browser. |
Date: | 2001-12-15 18:06:24 |
Message-ID: | 200112151806.fBFI6OC09388@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin pgsql-hackers |
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2001-12-15 19:32:56 | Re: [HACKERS] Requirement for pgAdmin browser. |
Previous Message | Jean-Michel POURE | 2001-12-15 15:00:03 | Re: Requirement for pgAdmin browser. |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-12-15 18:08:22 | Re: Problem compiling postgres sql --with-tcl |
Previous Message | Jean-Michel POURE | 2001-12-15 14:56:23 | Re: Requirement for pgAdmin browser. |