Thread

Re: [HACKERS] Column ADDing issues

Jose Soares <jose@sferacarta.com> — 2000-01-28T14:55:58Z

Bruce Momjian wrote:

> > > I suggest you be very cautious about messing with ALTER TABLE until you
> > > understand why inheritance makes it such a headache ;-)
> >
> > I'm just trying to get the defaults and constraints working. If
> > inheritance stays broken the way it previously was, it's beyond my
> > powers. But I get the feeling that people rather not alter their tables
> > unless they have *perfect* alter table commands. I don't feel like arguing
> > with them, they'll just have to do without then.
>
> OK, so am I hearing we don't want ALTER TABLE DROP COLUMN without it
> working for inhertance.  Is this really the way we want things?  May as
> well disable ADD COLUMN too because that doesn't work for inheritance
> either.
>

I think this is not a good idea. Many of us doesn't interest inheritance.
ALTER ADD COLUMN is not complete but it is better than nothing.

> --
>   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
>
> ************

--
Jose' Soares
Bologna, Italy                     Jose@sferacarta.com