RE: ALTER TABLE DROP COLUMN

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: ALTER TABLE DROP COLUMN
Дата
Msg-id EKEJJICOHDIEMGPNIFIJOEEOCHAA.Inoue@tpf.co.jp
обсуждение исходный текст
Ответ на Re: ALTER TABLE DROP COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ALTER TABLE DROP COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> -----Original Message-----
> From: Tom Lane
>
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > OK, I am opening this can of worms again.  I personally would like to
> > see this code activated, even if it does take 2x the disk space to alter
> > a column.  Hiroshi had other ideas.  Where did we leave this?  We have
> > one month to decide on a plan.
>
> I think the plan should be to do nothing for 7.1.  ALTER DROP COLUMN
> isn't an especially pressing feature, and so I don't feel that we
> should be hustling to squeeze it in just before beta.  We're already
> overdue for beta.
>

Seems some people expect the implementation in 7.1.
(recent [GENERAL} drop column?)
I could commit my local branch if people don't mind
backward incompatibility.
I've maintained the branch for more than 1 month
and it implements the following TODOs.

* Add ALTER TABLE DROP COLUMN feature
* ALTER TABLE ADD COLUMN to inherited table put column in wrong place
* Prevent column dropping if column is used by foreign key

Comments ?

Hiroshi Inoue

P.S. I've noticed that get_rte_attribute_name() seems to
break my implementation. I'm not sure if I could solve it.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: New unified regression test driver
Следующее
От: "Frederick W. Reimer"
Дата:
Сообщение: symbol not found in plpgsql.so