I wrote: > The situation is different for GENERATED columns, since we disallow > a child having a different GENERATED property than the parent.
BTW, that alleged prohibition is pretty damn leaky: d3=# create table pp1 (a int, b int GENERATED ALWAYS AS (a * 2) STORED); CREATE TABLE d3=# create table cc1 (a int, b int GENERATED ALWAYS AS (a * 3) STORED); CREATE TABLE d3=# alter table cc1 inherit pp1; ALTER TABLE Maybe the *real* fix here is to give up on this idea that they can't be different? regards, tom lane