Alvaro Herrera Munoz <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
