On 2/20/20 12:17 PM, Ted Toth wrote: > I'm a little confused why the before insert trigger fires al all but > since it does is there a way to know that an update will occur?
Because ON CONFLICT DO UPDATE is part of an INSERT command.
> Basically I don't want the trigger affect the row on update.
Not sure that a BEFORE trigger will work for that anyway as it will not have submitted the data yet for ON CONFLICT resolution.
I think you are right in that the trigger doesn't change the row being updated (which is good) but it also updates another table and that's what I'd actually like to avoid on update.