| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Taiki Yamaguchi <yamaguti(at)sra(dot)co(dot)jp> |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: A minor error in "5.8 Inheritance" |
| Date: | 2006-11-28 01:10:21 |
| Message-ID: | 26473.1164676221@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-11-28 10:37:55 | DTrace docs, Open Items and Performance |
| Previous Message | Taiki Yamaguchi | 2006-11-27 04:26:36 | A minor error in "5.8 Inheritance" |