Supabase PGRST202: Function Missing from Schema Cache
The newly created SQL function is not accessible by rpc(), although it is performed in SQL Editor. PostgREST uses schematic metadata and may need to be refreshed after changing the function signature.
How to determine the source of the error
Check the name, diagram, types of arguments and their names sent in rpc().
Verify whether the selected function is in the scheme available for the API and has the appropriate EXECUTE grants.
What to do step by step
1. Match the function definition to the actual call signature, without copying the old set of parameters.
2 . After changing functions, update the PostgREST cache according to the platform documentation.
How to check the score
The rpc call works for correct arguments, and the incorrect role still does not get unauthorised access.
What to do
Do not routinely change SECURITY INVOKER to DEFINITION without analyzing the consequences of the allowances.