Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AEF519FC04C for ; Thu, 8 Mar 2007 18:20:18 -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 76001-10 for ; Thu, 8 Mar 2007 18:20:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web54311.mail.yahoo.com (web54311.mail.yahoo.com [206.190.49.121]) by postgresql.org (Postfix) with SMTP id B7EF19FC01E for ; Thu, 8 Mar 2007 18:20:17 -0400 (AST) Received: (qmail 54425 invoked by uid 60001); 8 Mar 2007 22:20:16 -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=6ZpD1uTp/UzQr1USwqYNKsZBskkkR2ORTdb1qjwfb8D7Z6iL4IrDPR+1irAPZX59T36ht61pHDG9Et9aZYMtDqCpGAs8tjO1I9gghLANra8EFpecWVr0Iue/wlQN8RyjwtRa//HQCrR5QiiguAA+/v3stHy4X5cxK04iSquo37k=; X-YMail-OSG: 4rUU5XcVM1kiKL1pJ5r3INLGcEWmLIiQ1dRj9AB_fQDH3BB_aOMHbOXvWlQVJ_IwGaCBPPL.qVAjN1ZJ7BDuXFkslm4ltHkAmiI93QSbVfSnzTdPFC0Q2CADrmeyyUYqcCGjPcJVkw532y.Pc1e8davBmQ-- Received: from [24.10.123.39] by web54311.mail.yahoo.com via HTTP; Thu, 08 Mar 2007 14:20:16 PST Date: Thu, 8 Mar 2007 14:20:16 -0800 (PST) From: chester c young Subject: Re: inheritance To: Richard Broersma Jr , sql pgsql In-Reply-To: <534635.55952.qm@web31811.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <432034.54344.qm@web54311.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/88 X-Sequence-Number: 27726 --- Richard Broersma Jr wrote: > > > > Maybe then you'll add a table basket that has a foreign key to the > fruit > > table....... ;-) > > From the inheritance link: > ... > A serious limitation of the inheritance feature is that ... it's my understanding that inheritance has become much stronger in 8.2, although it still only inherits parts of the table. when primary keys and triggers are inherited then I'll be in heaven - until then rules rule. ____________________________________________________________________________________ Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. http://autos.yahoo.com/green_center/