Re: Triggers - Mailing list pgsql-general

From Tom Lane
Subject Re: Triggers
Date
Msg-id 7837.1029509884@sss.pgh.pa.us
Whole thread Raw
In response to Re: Triggers  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> Tom Lane wrote:
>>> I think we check constraints (including NOT NULL) before firing
>>> triggers.

> Seems like the trigger gets fired before the constraint checking.

A quick look in execMain.c demonstrates that you are correct.  I am not
sure why I thought otherwise --- maybe it was different a few releases
back?

            regards, tom lane

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: Triggers
Next
From: Oliver Elphick
Date:
Subject: Re: Triggers