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 по дате отправления: