Re: DROP COLUMN misbehaviour with multiple inheritance

From: Alvaro Herrera <alvherre(at)atentus(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: DROP COLUMN misbehaviour with multiple inheritance
Date: 2002-09-22 17:08:00
Message-ID: Pine.LNX.4.44.0209221301030.11862-100000@cm-lcon1-46-187.cm.vtr.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane dijo:

> It seems to me that DROP ONLY should set attislocal true on each child
> for which it decrements the inherit count, whether the count reaches
> zero or not. This would cause the behavior in the above case to be that
> c.f1 stays around after the second drop (but can be dropped with a third
> drop of c.f1 itself). I think this is correct, since the implication of
> DROP ONLY is that child columns are being cut loose from their parent's
> apron strings and now have independent existence.

Yes, I think it's more consistent the way you are proposing.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Acepta los honores y aplausos y perderas tu libertad"

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-09-22 19:54:35 Re: Postmaster help output
Previous Message Tom Lane 2002-09-22 17:05:40 Re: Schema vs Namespace

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2002-09-22 20:53:30 Re: Russian NLS Updates (pg_dump and postgres)
Previous Message Tom Lane 2002-09-22 16:56:23 Re: DROP COLUMN misbehaviour with multiple inheritance