Re: Multiple Inheritance

"Oliver Elphick" <olly(at)lfix(dot)co(dot)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