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. That would make it
> easier/cheaper/more reliable to match up which child columns are to be
> referenced in an inherited query (see adjust_inherited_attrs).
No way, because of multiple inheritance. Each child should have an
attparentnum, which would point to the parent's attnum for this to work ...
--
Alvaro Herrera (<[EMAIL PROTECTED]>)
"Aprender sin pensar es inútil; pensar sin aprender, peligroso" (Confucio)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
