How to call Postgres database functions from custom schema?

[Premjit-Developer]

I'm trying to create a custom schema and have added some functions to it, but I'm unsure how to call these functions properly. This is because rpc does not have schema parameter like get() or from().

[jan-tennert]

Seems like this functionality is missing currently. I'll add a parameter in a future version, for now you can follow the library's approach and set the header yourself (which specifies the schema used)
So it would look something like this:

postgrest.rpc("my_function") {
   headers["Content-Profile"] = "my_schema"
} 

[jan-tennert]

Try and see. It should work.

[Premjit-Developer]

Not working..

NotFoundRestException: Could not find the function public.get_all_foods(foodIds, userId) in the schema cache (Searched for the function public.get_all_foods with parameters foodIds, userId or with a single unnamed json/jsonb parameter, but no matches were found in the schema cache.)
                                   URL: https://pbzksx.supabase.co/rest/v1/rpc/get_all_foods
                                   Headers: [Authorization=[Bearer eyJhbGciOiJIUzI1NiIsImtpZCI6IkpOWWNEdmhFWXc2SD

[jan-tennert]

Yea, seems like the custom headers are currently ignored by the RPC request. I'll publish 2.6.1 with a fix. After this it should work.
A proper parameter will get introduced in 2.7.0.

[jan-tennert]

Can you try out version 2.6.1-dev?

[Premjit-Developer]

Dev version 2.6.1-dev is working perfectly.