Re: AW: ALTER TABLE DROP COLUMN

From: Chris <chris(at)bitmead(dot)com>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: PostgreSQL Development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: AW: ALTER TABLE DROP COLUMN
Date: 2000-10-16 07:57:12
Message-ID: 39EAB4D8.568F97C9@bitmead.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2000-10-16 08:21:09 Re: AW: ALTER TABLE DROP COLUMN
Previous Message Chris 2000-10-16 07:51:10 Re: AW: ALTER TABLE DROP COLUMN