Horton

Re: AW: 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: Don Baccus <dhogaza@pacifier.com>, Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>, "'Tom Lane'" <tgl@sss.pgh.pa.us>, The Hermit Hacker <scrappy@hub.org>, PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Date: 2000-10-15T14:12:13Z
Lists: pgsql-hackers 
> My trial implementation using physical/logical attribute numbers
> isn't so clean as I expected. I'm inclined to restrict my change to
> fix the TODO
> * ALTER TABLE ADD COLUMN to inherited table put column in wrong place
> though it would also introduce a backward compatibility.
> I could live without DROP COLUMN feature though I couldn't
> live without ADD COLUMN feature.

We have a DROP COLUMN option in the FAQ, so I don't see a rush there. 
Sounds like we need your fix for add column with inheritance, but I
suppose the 2x fix for DROP COLUMN could be used to add columns too.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  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