Re: [HACKERS] Allow child table to be missing nullable column from parent.

2013-08-22 Thread Tom Lane
Jeff Janes writes: > Currently a child table has to have all the columns the parent table has: > create table foo1 (x integer, y text, z bool); > create table foo2 (x integer, y text, q text); > alter table foo2 inherit foo1 ; > ERROR: child table is missing column "z" > In theory it seems like

[HACKERS] Allow child table to be missing nullable column from parent.

2013-08-22 Thread Jeff Janes
Currently a child table has to have all the columns the parent table has: create table foo1 (x integer, y text, z bool); create table foo2 (x integer, y text, q text); alter table foo2 inherit foo1 ; ERROR: child table is missing column "z" In theory it seems like this could be allowed as long a