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@aklaver.com