Re: logical column position - Mailing list pgsql-hackers

From Alvaro Herrera Munoz
Subject Re: logical column position
Date
Msg-id 20031120155716.GC24110@dcc.uchile.cl
Whole thread Raw
In response to Re: logical column position  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: logical column position
List pgsql-hackers
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 (<alvherre[@]dcc.uchile.cl>)
"Aprender sin pensar es in�til; pensar sin aprender, peligroso" (Confucio)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER COLUMN/logical column position
Next
From: Tom Lane
Date:
Subject: Re: logical column position