Re: before insert for each row trigger on upsert
От
Adrian Klaver
Тема
Re: before insert for each row trigger on upsert
Дата
Msg-id
18def70d-c2c4-ff92-b488-243ed0287001@aklaver.com
Ответ на
before insert for each row trigger on upsert (Ted Toth)
Список
Дерево обсуждения
before insert for each row trigger on upsert Ted Toth <txtoth@gmail.com>
Re: before insert for each row trigger on upsert Adrian Klaver <adrian.klaver@aklaver.com>
Re: before insert for each row trigger on upsert Ted Toth <txtoth@gmail.com>
Re: before insert for each row trigger on upsert Tom Lane <tgl@sss.pgh.pa.us>
Re: before insert for each row trigger on upsert Adrian Klaver <adrian.klaver@aklaver.com>
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
В списке pgsql-general по дате отправления
