public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Taiki Yamaguchi <[email protected]>
Cc: [email protected]
Subject: Re: A minor error in "5.8 Inheritance"
Date: Mon, 27 Nov 2006 20:10:21 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: A minor error in "5.8 Inheritance"
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox