pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDomains versus Check Constraints
3+ messages / 3 participants
[nested] [flat]
* Domains versus Check Constraints
@ 2007-05-22 16:56 Chander Ganesan <chander@otg-nc.com>
2007-05-27 15:59 ` Re: Domains versus Check Constraints Jim C. Nasby <decibel@decibel.org>
0 siblings, 1 reply; 3+ messages in thread
From: Chander Ganesan @ 2007-05-22 16:56 UTC (permalink / raw)
To: pgsql-performance
Are there any performance improvements that come from using a domain
over a check constraint (aside from the ease of management component)?
thanks
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Phone: 877-258-8987/919-463-0999
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Domains versus Check Constraints
2007-05-22 16:56 Domains versus Check Constraints Chander Ganesan <chander@otg-nc.com>
@ 2007-05-27 15:59 ` Jim C. Nasby <decibel@decibel.org>
2007-05-27 16:34 ` Re: Domains versus Check Constraints Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
0 siblings, 1 reply; 3+ messages in thread
From: Jim C. Nasby @ 2007-05-27 15:59 UTC (permalink / raw)
To: Chander Ganesan <chander@otg-nc.com>; +Cc: pgsql-performance
On Tue, May 22, 2007 at 12:56:21PM -0400, Chander Ganesan wrote:
> Are there any performance improvements that come from using a domain
> over a check constraint (aside from the ease of management component)?
No. Plus support for domain constraints isn't universal (plpgsql doesn't
honor them, for example).
--
Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Domains versus Check Constraints
2007-05-22 16:56 Domains versus Check Constraints Chander Ganesan <chander@otg-nc.com>
2007-05-27 15:59 ` Re: Domains versus Check Constraints Jim C. Nasby <decibel@decibel.org>
@ 2007-05-27 16:34 ` Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
0 siblings, 0 replies; 3+ messages in thread
From: Stefan Kaltenbrunner @ 2007-05-27 16:34 UTC (permalink / raw)
To: Jim C. Nasby <decibel@decibel.org>; +Cc: Chander Ganesan <chander@otg-nc.com>; pgsql-performance
Jim C. Nasby wrote:
> On Tue, May 22, 2007 at 12:56:21PM -0400, Chander Ganesan wrote:
>> Are there any performance improvements that come from using a domain
>> over a check constraint (aside from the ease of management component)?
>
> No. Plus support for domain constraints isn't universal (plpgsql doesn't
> honor them, for example).
since 8.2 domain constraints are enforced everywhere ...
Stefan
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-05-27 16:34 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-22 16:56 Domains versus Check Constraints Chander Ganesan <chander@otg-nc.com>
2007-05-27 15:59 ` Jim C. Nasby <decibel@decibel.org>
2007-05-27 16:34 ` Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox