Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns

KaiGai Kohei wrote:

>   postgres=# SELECT * FROM t2;
>   ERROR:  could not find inherited attribute "b" of relation "t3"
> 
> Because t3.b is also inherited from the t2, but ALTER TABLE does not
> care about multiple inherited columns well.
> 
> I think we should not allow to rename a column with attinhcount > 1.

I think we should fix ALTER TABLE to cope with multiple inheritance.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support