Re: Re: [PATCH] Allow queries in WHEN expression of FOR EACH STATEMENT triggers

2021-09-23 Thread Tom Lane
Joe Wildish" writes: > On Wed, 22 Sep 2021, at 17:09, Tom Lane wrote: > The main change is a switch to using SPI for expression evaluation. The > plans are also cached along the same lines as the RI trigger plans. >> >> I really dislike this implementation technique. Aside from the likely >> p

Re: Re: [PATCH] Allow queries in WHEN expression of FOR EACH STATEMENT triggers

2021-09-22 Thread Tom Lane
"Joe Wildish" writes: > The main change is a switch to using SPI for expression evaluation. The > plans are also cached along the same lines as the RI trigger plans. I really dislike this implementation technique. Aside from the likely performance hit for existing triggers, I think it opens se