Re: check constraint on insert but not delete

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: check constraint on insert but not delete
Дата
Msg-id AANLkTimVg=QbAJnHLjce3nSLmgNk7pzz7YCCts8jd5d3@mail.gmail.com
обсуждение исходный текст
Ответ на check constraint on insert but not delete  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Список pgsql-general
On Thu, Nov 4, 2010 at 11:03 AM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
> Is there a way to require that a check constraint be checked on insert but
> not update?    Worth knowing is that my check constraint runs a PLPgsql proc
> which returns a yes/no kinf of flag which the constraint proper checks.


Use an explicit ON INSERT trigger that calls your procedure instead of
a check constraint.

В списке pgsql-general по дате отправления: