Re: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "Ludwig Lim" <lud_nowhere_man(at)yahoo(dot)com>, "PostgreSQL Mailing List" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER
Date: 2002-12-16 16:56:31
Message-ID: 009301c2a524$15e39fc0$4201a8c0@beeblebrox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com> wrote:

> I am just wondering. Which one is executed first:
> CHECK Constraints or BEFORE INSERT OR UPDATE TRIGGER?

First the BEFORE... TRIGGERs, then the CHECK contraints,
so you definetly can change a row in a trigger to match
the contraints...

Regards,
Michael Paesold

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message javier garcia 2002-12-16 18:57:11 UPDATE with a SELECT and subSELECT(About comparing dates and non dates data)
Previous Message Ludwig Lim 2002-12-16 16:41:16 CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER