cache
I keep getting this error on my new functions.
So I tried reloading the scheme a few times. restarted my local dev server.
What else causes this to happen?
I looked into database function and cleared what became duplicates so I do not have several doing the same thing with same parameters.
my function looks like this
Not sure what to do
"If a new function was created in the database with this name and parameters, try reloading the schema cache.""Could not find the public.user_like_store(store_id, user_id) function or the public.user_like_store function with a single unnamed json or jsonb parameter in the schema cache".So I tried reloading the scheme a few times. restarted my local dev server.
NOTIFY pgrst, 'reload schema'What else causes this to happen?
I looked into database function and cleared what became duplicates so I do not have several doing the same thing with same parameters.
my function looks like this
create or replace function user_like_store(user_id uuid, id int)
returns void
as
$func$
update dev_stores_v3
set likes = array_append(likes, user_id)
where store_id = id
$func$
language sql,Not sure what to do
