Re: before insert for each row trigger on upsert

On 2/20/20 1:03 PM, Ted Toth wrote:
>
>
> On Thu, Feb 20, 2020 at 2:32 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> 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.

Hard to say what to do without knowing what the trigger function
actually does?

>
>
> >
> > Ted
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com