X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B9D46D81B9 for ; Sun, 9 Oct 2005 10:56:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47330-07 for ; Sun, 9 Oct 2005 13:56:49 +0000 (GMT) Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id CB0DED9634 for ; Sun, 9 Oct 2005 10:56:51 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 09 Oct 2005 10:57:33 -0300 Received: from alvh.no-ip.org (200.85.218.193) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 433A601F00619FAC; Sun, 9 Oct 2005 10:56:54 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id A7378C4F1EC; Sun, 9 Oct 2005 10:56:54 -0300 (CLST) Date: Sun, 9 Oct 2005 10:56:54 -0300 From: Alvaro Herrera To: Simon Riggs Cc: pgsql-docs@postgresql.org Subject: Re: Inheritance and Partitioning Message-ID: <20051009135654.GA5640@surnet.cl> Mail-Followup-To: Simon Riggs , pgsql-docs@postgresql.org References: <1128848392.8300.205.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1128848392.8300.205.camel@localhost.localdomain> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.986 required=5 tests=[AWL=-0.790, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: * X-Archive-Number: 200510/22 X-Sequence-Number: 3267 Simon Riggs wrote: > I'm currently doing the docs for CE & Partitioning. > > The ddl.sgml chapter had a section on Inheritance. I'm expanding that > section and splitting it into two: > > INHERITANCE & PARTITIONING > 1. Table Partitioning > Existing chapter, but with more detail of a general nature that > will be important information when we discuss... > > 2. Basic Partitioning using Constraint Exclusion > How to enhance inheritance with constraints to allow CE. How that > works to provide basic partitioning, with examples and long list of > caveats. Hmm, sorry, I missed most of the discussion on CE -- is it used only in inheritance? Maybe you should add a separate section on partitioning, referring to the inheritance section where appropiate. But they are clearly not the same feature. Also, it will be more clearly separated as we add more partitioning related features, right? -- Alvaro Herrera Architect, http://www.EnterpriseDB.com "A wizard is never late, Frodo Baggins, nor is he early. He arrives precisely when he means to." (Gandalf, en LoTR FoTR)