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.
Ted
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
