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