Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 56D609FA4F4 for ; Mon, 27 Nov 2006 00:58:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 45191-02 for ; Mon, 27 Nov 2006 00:58:35 -0400 (AST) X-Greylist: delayed 00:31:21.495476 by SQLgrey-1.7.4 Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by postgresql.org (Postfix) with ESMTP id DAC759FA48A for ; Mon, 27 Nov 2006 00:58:35 -0400 (AST) Received: from srascb.sra.co.jp (srascb [133.137.8.65]) by sraigw.sra.co.jp (Postfix) with ESMTP id 0A9C34275 for ; Mon, 27 Nov 2006 13:27:04 +0900 (JST) Received: from srascb.sra.co.jp (localhost [127.0.0.1]) by localhost.sra.co.jp (Postfix) with ESMTP id E74FF10CD07 for ; Mon, 27 Nov 2006 13:27:03 +0900 (JST) Received: from sranhm.sra.co.jp (sranhm [133.137.16.38]) by srascb.sra.co.jp (Postfix) with ESMTP id C411E10CD06 for ; Mon, 27 Nov 2006 13:27:03 +0900 (JST) Received: from [127.0.0.1] (dhcp-17-240.sra.co.jp [133.137.17.240]) by sranhm.sra.co.jp (8.9.3+3.2W/3.7W-srambox) with ESMTP id NAA20940 for ; Mon, 27 Nov 2006 13:27:03 +0900 Message-ID: <456A68FC.70106@sra.co.jp> Date: Mon, 27 Nov 2006 13:26:36 +0900 From: Taiki Yamaguchi User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: A minor error in "5.8 Inheritance" Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200611/81 X-Sequence-Number: 3915 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