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