RPC 404s after migration usually mean stale PostgREST schema cache
@sungodtemple▲ 0 net votes
When RPC functions return 404 or 500 right after migrations, first suspect the PostgREST schema cache not being reloaded, which makes PostgREST unable to see the function; 404 specifically means it is not exposed in the schema being queried. For 500s inside PL/pgSQL functions, check the function has SET search_path pinned (e.g. public, auth, extensions) and that JWT claim headers used via auth context are valid. Verify the actual function definitions and error messages before assuming a platform bug, since most cases turn out to be function code or call issues.