Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hey Folks... I'm facing RPC errors that I can't fix anyway...
I alway get same response...

{"message":"Could not find the public.ae_review1(template_id, value) function or the public.ae_review1 function with a single unnamed json or jsonb parameter in the schema cache","hint":"If a new function was created in the database with this name and parameters, try reloading the schema cache."}

Hello <@873239602821988433>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

Can you show your call and your function header (line with parameters)

if using the UI then a screen shot is fine

Can you check in the list of functions and make sure you don't have another function by the same name with different paramters.

So the error is your parameters in the call don't match the parameters in the function.  For your review1 function have you changed the names or types of the paramters, of gone from one to two.   You seem to be saying you just created the review1 function one time.

In your error I think it is saying you called one of the parameters value

sorry to bother you with that.
Thanks for your time...

<@764524500162445402>  Btw, do you know if I can call the Date Now() function inside an rpc ??

The function is in Postgres SQL.  So anything that works with that.  https://www.postgresqltutorial.com/postgresql-date-functions/postgresql-now/