Horton

Re: ALTER TABLE DROP COLUMN

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter_e@gmx.net>, PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Date: 2000-06-10T16:15:11Z
Lists: pgsql-hackers 
> > -----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, Pennsylvania 19026