Re: Domains versus Check Constraints - Mailing list pgsql-performance

From Stefan Kaltenbrunner
Subject Re: Domains versus Check Constraints
Date
Msg-id 4659B30E.5000802@kaltenbrunner.cc
Whole thread Raw
In response to Re: Domains versus Check Constraints  ("Jim C. Nasby" <decibel@decibel.org>)
List 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

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Next
From: PFC
Date:
Subject: Re: Feature suggestion : FAST CLUSTER