Re: User's responsibility when using a chain of "immutable" functions?

> On Jun 28, 2022, at 18:41, Bryn Llewellyn <bryn@yugabyte.com> wrote:
> Should I simply understand that when I have such a dynamic dependency chain of "immutable" functions, and should I drop and re-create the function at the start of the chain, then all bets are off until I drop and re-create every function along the rest of the chain?

Yes.

You don't have to drop and recreate the functions, though.  DISCARD PLANS handles it as well:

xof=# select f1(), f2(), f3();
 f1  | f2  | f3 
-----+-----+-----
 cat | cat | cat
(1 row)

xof=# drop function f1();
DROP FUNCTION

xof=# create function f1() returns text as $$ begin return 'dog'; end $$ language plpgsql immutable;
CREATE FUNCTION
xof=# select f1(), f2(), f3();
 f1  | f2  | f3 
-----+-----+-----
 dog | dog | cat
(1 row)