Re: Trigger function is not called

Tom Lane wrote:
> Bill <pg(at)dbginc(dot)com> writes:
>
>> The thing that has me confused is that the following table, trigger and
>> trigger function work perfectly and the primary key for this table is
>> also bigint not null.
>>
>
> Actually, after looking closer, I think the problem with your previous
> example is that you created an ON UPDATE trigger not an ON INSERT
> trigger. Table constraints are indeed enforced after before-triggers
> fire, as a quick look at the code proves. Sorry for the misinformation.
>
> regards, tom lane
>
>
>
I knew I was missing something really simple. I changed the trigger to
before insert and everything works perfectly. Thanks again for your
help. I learned a lot.

Bill