Re: [PERFORM] Domains versus Check Constraints
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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [PERFORM] Domains versus Check Constraints
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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) pgpHXSEWtrc1J.pgp Description: PGP signature
[PERFORM] Domains versus Check Constraints
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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
