Re: Multiple inheritance and ALTER TABLE issue - Mailing list pgsql-bugs

I wrote:
> Manuel Rigger <rigger.manuel@gmail.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