Re: A minor error in "5.8 Inheritance" - Mailing list pgsql-docs

From Tom Lane
Subject Re: A minor error in "5.8 Inheritance"
Date
Msg-id 26473.1164676221@sss.pgh.pa.us
Whole thread Raw
In response to A minor error in "5.8 Inheritance"  (Taiki Yamaguchi <yamaguti@sra.co.jp>)
List pgsql-docs
Taiki Yamaguchi <yamaguti@sra.co.jp> writes:
> I found a small error in "5.8 Inheritance" where it says:

> Check constraints can be defined on tables within an inheritance
> hierarchy. All check constraints on a parent table are automatically
> inherited by all of its children. Other types of constraints are not
> inherited, however.

> However, "not null" constraints also will be inherited. Unique
> constraints, primary key and foreign keys are not.

I think whoever wrote that had in mind that not-null constraints are a
special case of check constraints.  I agree it's clearer to spell it out
though.  Done, thanks for the report.

            regards, tom lane

pgsql-docs by date:

Previous
From: Taiki Yamaguchi
Date:
Subject: A minor error in "5.8 Inheritance"
Next
From: "Simon Riggs"
Date:
Subject: DTrace docs, Open Items and Performance