This is Liu Yuanyuan. I find the inherited table of column shown in pgadmin 1.20.0, sometimes isn’t right. That should be a bug. Hope someone to do something about this problem! Here is my example:
First I execute the following sql in pgadmin 1.20.0 by query tool: create schema test; create table test.a1(id int); create table test.a2(id int, name varchar); create table test.a3(age int); create table test.aa() inherits(test.a1,test.a2,test.a3);
I also check the code of pgadmin 1.20.0, I think the method to specify the inherited table of columns is not correct,especially when the inherited tables have same column.