Re: check constraint on insert but not delete - Mailing list pgsql-general

From Vick Khera
Subject Re: check constraint on insert but not delete
Date
Msg-id AANLkTimVg=QbAJnHLjce3nSLmgNk7pzz7YCCts8jd5d3@mail.gmail.com
Whole thread Raw
In response to check constraint on insert but not delete  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List 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 by date:

Previous
From: Mathieu De Zutter
Date:
Subject: Re: PHP Web Auditing and Authorization
Next
From: Richard Broersma
Date:
Subject: Re: check constraint on insert but not delete