Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 537A89FBB57 for ; Thu, 8 Mar 2007 18:27:54 -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 79397-07 for ; Thu, 8 Mar 2007 18:27:47 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31805.mail.mud.yahoo.com (web31805.mail.mud.yahoo.com [68.142.207.68]) by postgresql.org (Postfix) with SMTP id A153F9FB63A for ; Thu, 8 Mar 2007 18:27:50 -0400 (AST) Received: (qmail 16481 invoked by uid 60001); 8 Mar 2007 22:27:49 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=vvAfqBGS5u/u5hTN3QLFRrv/w24rvKf0zkqT1mimF/O4/QeSffK0hbHFoCNGVQGPYG1fzxJXowuyclSAvg+mBJ58kLLozRBMy78q3aNBFTjrPeqBs+HE/1dQ4Ecrw+FRAU7PesJJu6BA5k9r71PfdxVDG3um3rUL29+08Wb6Dyc=; X-YMail-OSG: W3pkV9cVM1mkfFFVmus9JFlHJtjtHTEopdmQhnrmAkdIm5eSeBZXbhMult.SLhN2.URgsMk6fg2KKFSKo6lqEPWKkN.S1CaF6VRPS3eZGmQr.qkFKeMUdr2fBQYD_p4ZvUJSlPSK3wc- Received: from [63.203.180.122] by web31805.mail.mud.yahoo.com via HTTP; Thu, 08 Mar 2007 14:27:49 PST Date: Thu, 8 Mar 2007 14:27:49 -0800 (PST) From: Richard Broersma Jr Subject: Re: inheritance To: chester c young , sql pgsql In-Reply-To: <432034.54344.qm@web54311.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <512635.16116.qm@web31805.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.344 tagged_above=0 required=5 tests=AWL, BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: ** X-Archive-Number: 200703/89 X-Sequence-Number: 27727 > > it's my understanding that inheritance has become much stronger in 8.2, > although it still only inherits parts of the table. True. But from what I understand, the only new feature that was added to table-inheritance was the ability to ALTER a table so that it inherits another table. Before this, I think table inheritance could only be created from the CREATE TABLE statement. Regards, Richard Broersma Jr.