Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D93FC1337E5E for ; Wed, 1 Dec 2010 10:47:27 -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 93972-02-5 for ; Wed, 1 Dec 2010 14:47:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 43C241337BD5 for ; Wed, 1 Dec 2010 10:41:11 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id oB1Ef8Ic015328; Wed, 1 Dec 2010 09:41:08 -0500 (EST) To: ghatpande@vsnl.net cc: Dann Corbit , pgsql hackers Subject: Re: Proposal: First step towards Intelligent, integrateddatabase In-reply-to: References: <87F42982BF2B434F831FCEF4C45FC33E4209B193@EXCHANGE.corporate.connx.com> Comments: In-reply-to ghatpande@vsnl.net message dated "Wed, 01 Dec 2010 15:46:12 +0500" Date: Wed, 01 Dec 2010 09:41:08 -0500 Message-ID: <15327.1291214468@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/48 X-Sequence-Number: 175310 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. regards, tom lane