Re: Triggers

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