Re: ALTER TABLE DROP COLUMN

> > -----Original Message-----
> > From: pgsql-hackers-owner@hub.org 
> > [mailto:pgsql-hackers-owner@hub.org]On Behalf Of Bruce Momjian
> > 
> > Seems we have 4 DROP COLUMN ideas:
> > 
> >     Method                                                  Advantage
> >     -----------------------------------------------------------------
> > 1    invisible column marked by negative attnum        fast
> > 2    invisible column marked by is_dropped column        fast
> > 3    make copy of table without column            col removed
> > 4    make new tuples in existing table without column    col removed
> > 
> > Folks, we had better choose one and get started.  
> > 
> > Number 1 Hiroshi has ifdef'ed out in the code.  Items 1 and 2 have
> > problems with backend code and 3rd party code not seeing the dropped
> > columns,
> 
> Hmm,doesn't  *not seeing*  mean the column is dropped ?

I meant problems of backend code and 3rd party code _seeing_ the dropped
column in pg_attribute.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026