Re: Domains versus Check Constraints

Поиск
Список
Период
Сортировка
От Stefan Kaltenbrunner
Тема Re: Domains versus Check Constraints
Дата
Msg-id 4659B30E.5000802@kaltenbrunner.cc
обсуждение исходный текст
Ответ на Re: Domains versus Check Constraints  ("Jim C. Nasby" <decibel@decibel.org>)
Список 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 по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
Следующее
От: PFC
Дата:
Сообщение: Re: Feature suggestion : FAST CLUSTER