when I look at the example provided by supabase (here) I see some differences with your code, particularly your lack of schema prefixes for the function and not setting the search path. The supabase doco (here) also says when executing the function as definer you must also specify the search path.