Re: A minor error in "5.8 Inheritance"

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: A minor error in "5.8 Inheritance"
Дата
Msg-id
26473.1164676221@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
A minor error in "5.8 Inheritance" Taiki Yamaguchi <yamaguti@sra.co.jp>
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
В списке pgsql-docs по дате отправления
От: Taiki Yamaguchi
Дата:
От: Simon Riggs
Дата:
FAQ