| From: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Re: Feature Request |
| Date: | 2000-02-23 22:40:14 |
| Message-ID: | 20000223164014.E6190@rice.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Feb 22, 2000 at 08:23:17PM -0500, Bruce Momjian wrote:
> > Dear Mr Momjian
> >
> > Just a quick suggestion for an added feature: "DROP COLUMN columnname
> > FROM table..." and "ALTER COLUMN columname FROM table..." queries would
> > spare my hair when I make mistakes in table creation.
>
> We have the DROP, but will not appear in 7.0.
One last little note on the whole DROP COLUMN discussion:
A snip from Phil Greenspun's photo.net site:
"Adding a column to a relational database table seldom breaks
queries. Until Oracle 8.1.5, you weren't able to drop a column."
My guess would be that Oracle found out internally what we've been
discussing here: doing DROP COLUMN right is _hard_.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-02-23 22:40:47 | Re: [HACKERS] Cache query (PREPARE/EXECUTE) |
| Previous Message | Bruce Momjian | 2000-02-23 20:12:54 | Changes in 7.0 |