On Mon, Nov 19, 2018 at 4:36 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > Merlin Moncure <mmoncure@xxxxxxxxx> writes: > > On Mon, Nov 19, 2018 at 11:56 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > >> The search_path in the trigger probably doesn't include public. > >> You could add a "SET search_path = whatever" clause to the trigger > >> function definition to ensure it runs with a predictable path. > > > Might be worth considering: > > SET LOCAL search_path = whatever > > So that LOCAL makes the change local to the transaction. > > What I was suggesting was to create the trigger function using > > create function ... as $$ ...body... $$ set search_path = whatever; > > That makes the setting local to each function call. Oh, I see. Yes, that's even better. merlin
