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
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