Re: logical column position

Alvaro Herrera Munoz <alvherre@dcc.uchile.cl> writes:
> On Thu, Nov 20, 2003 at 10:39:24AM -0500, Tom Lane wrote:
> (c) Do I need to consider inheritance?
>> 
>> Yes.  I think it'd be good if things were constrained so that columns
>> 1..n in a parent table always matched columns 1..n in every child,
>> which is not true now after adding/dropping columns.

> No way, because of multiple inheritance.  Each child should have an
> attparentnum, which would point to the parent's attnum for this to work ...

Hm, good point.  And I think we merge identically-named columns
inherited from different parents, which would mean that "attparentnum"
wouldn't have a unique value anyway.

Perhaps rearranging a parent's columns shouldn't have *any* direct
effect on a child?  Seems ugly though.
        regards, tom lane