Re: [SQL] Inherits is not encouraged?

2009-03-09 Thread Tom Lane
Emi Lu writes: > (1) Is possible that I could change the column of a table that is > defined by Inherits? > e.g., t1(col1, col2, col3); create table tx(colx) Inherits (t1) > I'd like to get tx shown as (col1, colx, col2, col3). No, you don't really have a lot of control over that. It'll stick

[SQL] Inherits is not encouraged?

2009-03-09 Thread Emi Lu
Good morning, I have two questions about inherits under postgreSQL 8.0.15. (1) Is possible that I could change the column of a table that is defined by Inherits? e.g., t1(col1, col2, col3); create table tx(colx) Inherits (t1) I'd like to get tx shown as (col1, colx, col2, col3). (2) Logica