Re: Multiple inheritance and ALTER TABLE issue

I wrote:
> Manuel Rigger <rigger(dot)manuel(at)gmail(dot)com> writes:
>> Consider the test case below:

>> CREATE TABLE t0(c0 boolean);
>> CREATE TABLE t1(c0 boolean);
>> CREATE TABLE t2(c0 boolean) INHERITS(t0, t1);
>> ALTER TABLE t0 ALTER c0 TYPE TEXT;
>> UPDATE t1 SET c0 = TRUE; -- ERROR: attribute "c0" of relation "t2"
>> does not match parent's type

>> Is this behavior intended?

> Hm. I would say that the ALTER COLUMN TYPE operation should have thrown
> an error instead of trying to change the type of a multiply-inherited
> column. As you say, no good can come of that.

I've pushed a fix along that line. Thanks for the report!

regards, tom lane