Re: Multiple Inheritance

"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