public inbox for [email protected]
help / color / mirror / Atom feedA minor error in "5.8 Inheritance"
2+ messages / 2 participants
[nested] [flat]
* A minor error in "5.8 Inheritance"
@ 2006-11-27 04:26 Taiki Yamaguchi <[email protected]>
2006-11-28 01:10 ` Re: A minor error in "5.8 Inheritance" Tom Lane <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Taiki Yamaguchi @ 2006-11-27 04:26 UTC (permalink / raw)
To: pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: A minor error in "5.8 Inheritance"
2006-11-27 04:26 A minor error in "5.8 Inheritance" Taiki Yamaguchi <[email protected]>
@ 2006-11-28 01:10 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2006-11-28 01:10 UTC (permalink / raw)
To: Taiki Yamaguchi <[email protected]>; +Cc: pgsql-docs
Taiki Yamaguchi <[email protected]> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-11-28 01:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-27 04:26 A minor error in "5.8 Inheritance" Taiki Yamaguchi <[email protected]>
2006-11-28 01:10 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox