Re: BUG #4291: Inheritance fails on column suppression - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4291: Inheritance fails on column suppression
Date
Msg-id 1360.1215700459@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4291: Inheritance fails on column suppression  ("Duprez" <c.duprez@libertysurf.fr>)
List pgsql-bugs
"Duprez" <c.duprez@libertysurf.fr> writes:
> Then, I remove th inheritance link by performing an ALTER command :
> ALTER TABLE test2.point NO INHERIT test1.point;
> And then, I restablish the inheritance :
> ALTER TABLE test2.point INHERIT test1.point;
> The problem is that, if now I drop a column from the parent table, the
> column remains in the child table, whereas the inheritance is established :

This is not a bug.  Once the child was dis-inherited, all its columns
became locally defined, and they'd stay that way on re-inheritance.
(There is no memory in the system that would allow us to determine that
the attislocal flag should be removed --- that is, we can't tell
this case from the case where column test2 was declared locally in
the original child table definition.  It doesn't seem worth adding
still more complexity to the column inheritance state just to cover this.)

> According to the documentation, this should not be the case.

Please state where you think the documentation says that, so we
can fix it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: BUG #4292: directory pg_clog never cleaned
Next
From: Simon Riggs
Date:
Subject: Re: BUG #4294: XML support: name() xpath function not working