Re: A minor error in "5.8 Inheritance"

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Taiki Yamaguchi <yamaguti(at)sra(dot)co(dot)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