public inbox for [email protected]
help / color / mirror / Atom feedCaveat for Domains
5+ messages / 2 participants
[nested] [flat]
* Caveat for Domains
@ 2005-09-09 21:58 David Fetter <[email protected]>
0 siblings, 2 replies; 5+ messages in thread
From: David Fetter @ 2005-09-09 21:58 UTC (permalink / raw)
To: pgsql-docs; PostgreSQL Patches <[email protected]>
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>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PATCHES] Caveat for Domains
@ 2005-09-16 19:52 Bruce Momjian <[email protected]>
parent: David Fetter <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2005-09-16 19:52 UTC (permalink / raw)
To: David Fetter <[email protected]>; +Cc: pgsql-docs; PostgreSQL Patches <[email protected]>
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
---------------------------------------------------------------------------
David Fetter wrote:
> 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!
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PATCHES] Caveat for Domains
@ 2005-09-22 23:57 Bruce Momjian <[email protected]>
parent: David Fetter <[email protected]>
1 sibling, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2005-09-22 23:57 UTC (permalink / raw)
To: David Fetter <[email protected]>; +Cc: pgsql-docs; PostgreSQL Patches <[email protected]>
Patch applied. Thanks.
---------------------------------------------------------------------------
David Fetter wrote:
> 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!
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PATCHES] Caveat for Domains
@ 2005-10-20 05:49 David Fetter <[email protected]>
parent: Bruce Momjian <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: David Fetter @ 2005-10-20 05:49 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: pgsql-docs; PostgreSQL Patches <[email protected]>
On Thu, Sep 22, 2005 at 07:57:35PM -0400, Bruce Momjian wrote:
> Patch applied. Thanks.
Could you please put fixing domains for functions on the TODO list?
Cheers,
D
>
> ---------------------------------------------------------------------------
>
>
> David Fetter wrote:
> > 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!
>
> [ Attachment, skipping... ]
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> [email protected] | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
David Fetter [email protected] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [PATCHES] Caveat for Domains
@ 2005-10-24 18:09 Bruce Momjian <[email protected]>
parent: David Fetter <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2005-10-24 18:09 UTC (permalink / raw)
To: David Fetter <[email protected]>; +Cc: pgsql-docs; PostgreSQL Patches <[email protected]>
David Fetter wrote:
> On Thu, Sep 22, 2005 at 07:57:35PM -0400, Bruce Momjian wrote:
>
> > Patch applied. Thanks.
>
> Could you please put fixing domains for functions on the TODO list?
Added to TODO:
* Allow user-defined functions retuning a domain value to enforce domain
constraints
---------------------------------------------------------------------------
>
> Cheers,
> D
>
> >
> > ---------------------------------------------------------------------------
> >
> >
> > David Fetter wrote:
> > > 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!
> >
> > [ Attachment, skipping... ]
> >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 6: explain analyze is your friend
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > [email protected] | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
>
> --
> David Fetter [email protected] http://fetter.org/
> phone: +1 510 893 6100 mobile: +1 415 235 3778
>
> Remember to vote!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-10-24 18:09 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-09 21:58 Caveat for Domains David Fetter <[email protected]>
2005-09-16 19:52 ` Bruce Momjian <[email protected]>
2005-09-22 23:57 ` Bruce Momjian <[email protected]>
2005-10-20 05:49 ` David Fetter <[email protected]>
2005-10-24 18:09 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox