Re: [HACKERS] Table Inheritance and dropped columns

2009-01-27 Thread Tom Lane
Caleb Welton writes: > Two child tables, one created with inheritance, one altered to have > inheritance: > When you drop a column from the parent table only the tables CREATED with > inheritance drop the column: Yeah, this is intentional. The other table is presumed to still own its columns eve

[HACKERS] Table Inheritance and dropped columns

2009-01-27 Thread Caleb Welton
Hello, I'm trying to figure out if this is a bug or a feature. Two child tables, one created with inheritance, one altered to have inheritance: create table A(a text, b text); create table A1() inherits (A); create table A2(a text, b text); alter table A2 INHERIT A; When you dro