Re: BETWEEN Node & DROP COLUMN

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: BETWEEN Node & DROP COLUMN
Date: 2002-07-04 00:26:01
Message-ID: 3D239619.A8274AA2@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
>
> Christopher Kings-Lynne wrote:
> > Hi All,
> >
> > I have given up working on the BETWEEN node. It got to the stage where I
> > realised I was really out of my depth! Rod Taylor has indicated an interest
> > in the problem and I have sent him my latest patch, so hopefully he'll be
> > able to crack it.
> >
> > So instead, I've taken up with the DROP COLUMN crusade. It seems that the
> > following are the jobs that need to be done:
>
> Great crusade!
>
> > * Add attisdropped to pg_attribute
> > - Looking for takers for this one, otherwise I'll look into it.
>
> I can do this for you. Just let me know when.
>
> > * Fill out AlterTableDropColumn
> > - I've done this, with the assumption that attisdropped exists. It sets
> > attisdropped to true, drops the column default and renames the column.
> > (Plus does all other normal ALTER TABLE checks)
> > * Modify parser and other places to ignore dropped columns
> > - This is also up for grabs.
>
> As I remember, Hiroshi's drop column changed the attribute number to a
> special negative value, which required lots of changes to track.

??? What do you mean by *lots of* ?

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-07-04 00:37:24 Re: BETWEEN Node & DROP COLUMN
Previous Message Bruce Momjian 2002-07-04 00:25:55 Re: BETWEEN Node & DROP COLUMN