Postgres Pro
Downloads
Home   >   mailing lists

Re: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER - Mailing list pgsql-sql

From Michael Paesold
Subject Re: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER
Date
Msg-id 009301c2a524$15e39fc0$4201a8c0@beeblebrox
Whole thread Raw
In response to CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER  (Ludwig Lim <lud_nowhere_man@yahoo.com>)
List pgsql-sql
Tree view 
Ludwig Lim <lud_nowhere_man@yahoo.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

pgsql-sql by date:

Previous
From: Ludwig Lim
Date:
Subject: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER
Next
From: javier garcia
Date:
Subject: UPDATE with a SELECT and subSELECT(About comparing dates and non dates data)