X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 5324BD8B93;
	Fri,  9 Sep 2005 18:58:28 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 64259-08; Fri,  9 Sep 2005 21:58:24 +0000 (GMT)
Received: from fetter.org (dsl092-188-065.sfo1.dsl.speakeasy.net
	[66.92.188.65])
	by svr1.postgresql.org (Postfix) with ESMTP id 37633D7015;
	Fri,  9 Sep 2005 18:58:24 -0300 (ADT)
Received: from fetter.org (localhost.localdomain [127.0.0.1])
	by fetter.org (8.13.4/8.12.10) with ESMTP id j89LwQjF003000;
	Fri, 9 Sep 2005 14:58:27 -0700
Received: (from shackle@localhost)
	by fetter.org (8.13.4/8.13.4/Submit) id j89LwQLM002999;
	Fri, 9 Sep 2005 14:58:26 -0700
Date: Fri, 9 Sep 2005 14:58:26 -0700
From: David Fetter <david@fetter.org>
To: PostgreSQL Docs <pgsql-docs@postgresql.org>,
	PostgreSQL Patches <pgsql-patches@postgresql.org>
Subject: Caveat for Domains
Message-ID: <20050909215826.GA2566@fetter.org>
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="tThc/1wpZn/ma/RB"
Content-Disposition: inline
User-Agent: Mutt/1.4.2.1i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.059 required=5 tests=[AWL=0.009,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200509/18
X-Sequence-Number: 3204


--tThc/1wpZn/ma/RB
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Folks,

I think this needs to be made explicit in the documentation.  Better,
of course, would be some kind of change to the PL infrastructure that
Just Handles It, but until then....

Cheers,
D
-- 
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

--tThc/1wpZn/ma/RB
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename="d0m41n_fux0r3d.diff"

Index: doc/src/sgml/ref/create_domain.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/create_domain.sgml,v
retrieving revision 1.22
diff -c -r1.22 create_domain.sgml
*** doc/src/sgml/ref/create_domain.sgml	2 May 2005 01:52:50 -0000	1.22
--- doc/src/sgml/ref/create_domain.sgml	9 Sep 2005 21:21:39 -0000
***************
*** 48,57 ****
    </para>
  
    <para>
!    Domains are useful for abstracting common fields between tables into
!    a single location for maintenance.  For example, an email address column may be used
!    in several tables, all with the same properties.  Define a domain and
!    use that rather than setting up each table's constraints individually.
    </para>
   </refsect1>
  
--- 48,60 ----
    </para>
  
    <para>
!    Domains are useful for abstracting common fields between tables
!    into a single location for maintenance.  For example, an email address
!    column may be used in several tables, all with the same properties.
!    Define a domain and use that rather than setting up each table's
!    constraints individually. <note>Keep in mind also that declaring a
!    function result value as a domain is pretty dangerous, because none of
!    the PLs enforce domain constraints on their results.</note>
    </para>
   </refsect1>
  

--tThc/1wpZn/ma/RB--