Re: AW: ALTER TABLE DROP COLUMN

Поиск
Список
Период
Сортировка
От Chris
Тема Re: AW: ALTER TABLE DROP COLUMN
Дата
Msg-id 39EAB4D8.568F97C9@bitmead.com
обсуждение исходный текст
Ответ на RE: AW: ALTER TABLE DROP COLUMN  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
Hiroshi Inoue wrote:

> When I used Oracle,I saw neither option of DROP 
> COLUMN feature. It seems to tell us that the 
> implementation isn't
> that easy. It may not be a bad choise to give up DROP
> COLUMN feature forever.

Because it's not easy we shouldn't do it? I don't think so. The perfect
solution is lazy updating of tuples but it requires versioning of
meta-data and that requires a bit of work.

> However I would strongly object to 2x
> ADD COLUMN if such implementations are proposed. 

Not even 2x for ADD COLUMN DEFAULT ?


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

Предыдущее
От: Chris
Дата:
Сообщение: Re: AW: ALTER TABLE DROP COLUMN
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: AW: ALTER TABLE DROP COLUMN