Re: A minor error in "5.8 Inheritance"

Поиск
Список
Период
Сортировка
Искать

Re: A minor error in "5.8 Inheritance"

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Taiki Yamaguchi  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

A minor error in "5.8 Inheritance"

От:
Taiki Yamaguchi <yamaguti@sra.co.jp>
Дата:
Hi,

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.


--
Taiki Yamaguchi
FAQ