Renamed Table, broke edge function

I had a working edge function called by a trigger which then updated the table that called it. I renamed the table that was making the call, and then repointed the edge function back to that same table in the JS. But it's somehow attached to the original table name. The original table name was ios_apps. That's been renamed to ios_app_lookups. I've scoured every piece of code in my system and there's no remaining reference to ios_apps. But the edge function won't stop looking for it. I get this error every time: "message":"relation "public.ios_apps" does not exist" Here's the relevant JS Code: * const { data, error } = await supabase .from('ios_app_lookups') .update({ s_appstore_id:s.id, s_app_name:s.title, s_app_identifier:s.bundle_id, s_app_version:s.version, s_content_rating:s.age_rating, // s_app_description:s.description, s_appstore_url:s.link, s_price:s.price.extracted_price, s_average_user_rating:s.rating, s_reviews:s.reviews, s_genre:s.genres,
s_app_vendor:s.developer.name, s_icon:s.logos[0].link, s_app_bundle_size:s.size_in_bytes, }) .eq('id', id) .select()*
No description
No description
3 Replies
garyaustin
garyaustin5h ago
You might try flushing Postgres cache but really hard to tell Check api gateway log to see the exact query your edge function calls. NOTIFY pgrst, 'reload schema' in the SQL editor.
MyLizard
MyLizardOP4h ago
Flushing the cache seems like it's on the right track, but that command didn't change anything.
Running this in the UI returns nothing:
No description
MyLizard
MyLizardOP4h ago
How do I access those logs on CLI? Ah! Found it. It was a downstream trigger reference that somehow managed to get itself recognized as an edge function error.

Did you find this page helpful?