Category: Supabase and databases

Supabase PGRST202: Function Missing from Schema Cache

Read this guide in Polish

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.