Re: ALTER TABLE DROP COLUMN

> > -----Original Message-----
> > From: pgsql-hackers-owner(at)hub(dot)org
> > [mailto:pgsql-hackers-owner(at)hub(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026