| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Re: Feature Request |
| Date: | 2000-02-23 23:03:28 |
| Message-ID: | 3.0.1.32.20000223150328.010d5a60@mail.pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
At 04:40 PM 2/23/00 -0600, Ross J. Reedstrom wrote:
>"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_.
They ended up providing both kinds of drop that have been discussed
here, i.e. a slow one that actually mucks through the table getting
rid of physical data, and a quick one that simply marks the column
as being invisible resulting in it being ignored in the future.
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Baccus | 2000-02-23 23:17:18 | Re: [HACKERS] interesting observatation regarding views and V7.0 |
| Previous Message | Tom Lane | 2000-02-23 22:54:36 | Re: [HACKERS] interesting observatation regarding views and V7.0 |