Home > mailing lists

before insert for each row trigger on upsert - Mailing list pgsql-general

From	Ted Toth
Subject	before insert for each row trigger on upsert
Date	February 20, 2020 20:17:25
Msg-id	CAFPpqQH+6_mbJV2f5Nzm21Bg-G9GU_b91irDg+==y=6aMKgjVw@mail.gmail.com Whole thread Raw
Responses	Re: before insert for each row trigger on upsert
List	pgsql-general

Tree view

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? Basically I don't want the trigger affect the row on update.

Ted

pgsql-general by date:

From: Tom Lane
Date: 20 February 2020, 19:47:47
Subject: Re: Error “cache lookup failed for function”

From: Adrian Klaver
Date: 20 February 2020, 20:32:09
Subject: Re: before insert for each row trigger on upsert

before insert for each row trigger on upsert - Mailing list pgsql-general

Previous

Next