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