Re: Deferrerable Check constraints

--- On Mon, 11/24/08, Luiz K. Matsumura <luiz@planit.com.br> wrote:

> Hi All,
>
> Need a Help. Can a check constraint be deferred until the
> end of a transaction  ?
> In other words, if i have a constraint like this:
>
> CREATE TABLE test
> (
>  id serial NOT NULL,
>  qt1 integer NOT NULL DEFAULT 0,
>  qt2 integer NOT NULL DEFAULT 0,
>  CONSTRAINT check_qt CHECK (qt1 <= qt2)
> )
>
> There are some manner that allow qt1 to be greater than qt2
> on a intermediate state of the transaction ?

Is this something that could be handled with update and/or insert triggers?

Bruce