On Tue, Jul 27, 2021 at 4:04 PM Nicolas Mitchell <mitchelln(at)posteo(dot)net>
wrote:
>
> > When you write a trigger for a table you should be executing commands
> > against the same table.
>
> I believe this implies that the code creating a new object (INSERT INTO
> public.object…) row should reside elsewhere.
>
>
Since the trigger is on host but the insert is going to object my
observation does not apply.
Personally, I'm generally against placing this kind of data construction
logic inside triggers.
David J.