Re: [GENERAL] inheritence children with integer columns of differing width

2017-06-19 Thread Tom Lane
Justin Pryzby writes: > I wondered if anyone had considered allowing inheritence children to have > different column types than the parent (and each other). No, and it's not sane to consider it. > I'm thinking of the trivial (?) case of smallint/int/bigint. What's trivial about that? Consider

[GENERAL] inheritence children with integer columns of differing width

2017-06-19 Thread Justin Pryzby
I wondered if anyone had considered allowing inheritence children to have different column types than the parent (and each other). I'm thinking of the trivial (?) case of smallint/int/bigint. Reason is that when we load data which exceeds the theshold for the current data type we have to promote