public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Fetter <[email protected]>
To: PostgreSQL Docs <[email protected]>
To: PostgreSQL Patches <[email protected]>
Subject: Caveat for Domains
Date: Fri, 9 Sep 2005 14:58:26 -0700
Message-ID: <[email protected]> (raw)

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 [email protected] http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

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>
  


Attachments:

  [text/plain] d0m41n_fux0r3d.diff (1.3K, 2-d0m41n_fux0r3d.diff)
  download | inline 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>
  

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Caveat for Domains
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox