"Oliver Elphick" <olly@lfix.co.uk> writes:
> It's in the man page for create_table:
> inherited_table
> The optional INHERITS clause specifies a list of
> table names from which this table automatically
> inherits all fields. If any inherited field name
> appears more than once, Postgres reports an error.
Hmm, this bit of the documentation is wrong:
regression=# create table p1 (f1 int, f2 float);
CREATE
regression=# create table p2 (f1 int, f2 float, f3 int);
CREATE
regression=# create table c1(f4 int) inherits (p1,p2);
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute "f1"
NOTICE: CREATE TABLE: merging multiple inherited definitions of attribute "f2"
CREATE
regression=#
The NOTICE is new in 7.1, but prior versions did this sort of merging
as well. Will fix the docs.
regards, tom lane