X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4A050D1C918 for ; Fri, 1 Aug 2003 23:56:32 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 79636-09 for ; Fri, 1 Aug 2003 20:55:26 -0300 (ADT) Received: from lakemtao02.cox.net (lakemtao02.cox.net [68.1.17.243]) by svr1.postgresql.org (Postfix) with ESMTP id 561DBD1C914 for ; Fri, 1 Aug 2003 20:56:30 -0300 (ADT) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao02.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030801235632.HMVD24359.lakemtao02.cox.net@[192.168.1.1]> for ; Fri, 1 Aug 2003 19:56:32 -0400 Subject: Re: Domains (Was [PERFORM] Views With Unions) From: Ron Johnson To: pgsql General List In-Reply-To: <20030801131642.Q93127@zoraida.natserv.net> References: <20030801075335.D51229-100000@megazone.bigpanda.com> <60vfthl6q6.fsf@dev6.int.libertyrms.info> <16388.1059756693@sss.pgh.pa.us> <20030801131642.Q93127@zoraida.natserv.net> Content-Type: text/plain Message-Id: <1059782193.22384.85.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 01 Aug 2003 18:56:33 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/74 X-Sequence-Number: 46491 On Fri, 2003-08-01 at 12:26, Francisco J Reyes wrote: > On Fri, 1 Aug 2003, Tom Lane wrote: [snip] > accros some tables. Currently I used inheritance to enforce the consitency > since a good number of fields needed to be common among the tables AND the > inheritted tables are basically a supperset of the data, so some times I > would want to access the inheritted tables and other times the parent/main > table. Isn't this when you'd really want child tables, instead? -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+