Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id EE3711337C5C for ; Wed, 1 Dec 2010 11:01:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 30851-01-10 for ; Wed, 1 Dec 2010 15:01:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from cdptpa-omtalb.mail.rr.com (cdptpa-omtalb.mail.rr.com [75.180.132.120]) by mail.postgresql.org (Postfix) with ESMTP id D933E1337C57 for ; Wed, 1 Dec 2010 10:59:17 -0400 (AST) X-Authority-Analysis: v=1.1 cv=Inhw+Jdt7z1D3BivGPfn2aw54OvUEJw5lAn/booRZkE= c=1 sm=0 a=fmZU9HhHqnwA:10 a=8nJEP1OIZ-IA:10 a=qCTYjJJ2g1SgQhsHZAUATw==:17 a=kedO5TclAAAA:8 a=FV4SY87oDwro_2ja7HwA:9 a=XJ-jw9Ev_2Pgls0xyQcA:7 a=otxrwSR5hb_xEHjAxNjtqXr_ixQA:4 a=wPNLvfGTeEIA:10 a=a-DErYXbi0MA:10 a=qCTYjJJ2g1SgQhsHZAUATw==:117 X-Cloudmark-Score: 0 X-Originating-IP: 98.27.48.207 Received: from [98.27.48.207] ([98.27.48.207:51043] helo=[192.168.10.104]) by cdptpa-oedge04.mail.rr.com (envelope-from ) (ecelerity 2.2.3.46 r()) with ESMTP id 08/1F-13137-5C266FC4; Wed, 01 Dec 2010 14:59:18 +0000 Message-ID: <4CF662C5.70109@dunslane.net> Date: Wed, 01 Dec 2010 09:59:17 -0500 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.12) Gecko/20101027 Fedora/3.1.6-1.fc13 Lightning/1.0b3pre Thunderbird/3.1.6 MIME-Version: 1.0 To: Tom Lane CC: ghatpande@vsnl.net, Dann Corbit , pgsql hackers Subject: Re: Proposal: First step towards Intelligent, integrateddatabase References: <87F42982BF2B434F831FCEF4C45FC33E4209B193@EXCHANGE.corporate.connx.com> <15327.1291214468@sss.pgh.pa.us> In-Reply-To: <15327.1291214468@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201012/53 X-Sequence-Number: 175315 On 12/01/2010 09:41 AM, Tom Lane wrote: > ghatpande@vsnl.net writes: >> Create domain is only useful for abstracting common constraints on fields into single location for maintenance. It may not be useful to link tables. > It's still unclear what this does that you don't get from inheritance, > typed tables, use of a table's rowtype as a field type, or CREATE TABLE > LIKE. This isn't exactly virgin territory. > > Yeah. Actually, the whole thing reminded me somewhat of the pre-RDBMS data stores I worked with 25 years or so ago. "Those who cannot remember history are doomed to repeat it." cheers andrew