On Monday, January 24, 2022, Dominique Devienne <ddevienne@gmail.com> wrote:
After re-reading https://www.postgresql.org/docs/14/sql-createfunction.html in light of Tom's answer, does that mean that our `SET search_path TO {0}, 'pg_temp'` workaround, in the trigger below, to not depend on the search_path at runtime:
The general trigger documentation is kind enough to point out that the sql language cannot be used to write trigger functions.