© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4mo ago•
31 replies
MyLizard

42P01 error from edge function

I have an edge function that was working and then stopped. I can't think of what I changed, and I have another almost-identical edge function that works fine on the same database. The only difference is which table they're calling.

The error I get is this:
"Error posting data: {\n  code: \"42P01\",\n  details: null,\n  hint: null,\n  message: 'relation \"android_app_lookups\" does not exist'\n}\n"
"Error posting data: {\n  code: \"42P01\",\n  details: null,\n  hint: null,\n  message: 'relation \"android_app_lookups\" does not exist'\n}\n"


This is the code section that generates the error:
  const { data, error } = await supabase.from('android_app_lookups').update({
    s_title: s.title,
    s_product_id: s.product_id,
    s_authors: s.authors,
    s_developer_contact: s.developer_contact,
    s_extensions: s.extensions,
    s_release_date: s.release_date,
    s_rating: s.rating,
    s_reviews: s.reviews,
    s_downloads: s.downloads,
    s_content_rating: s.content_rating,
    s_rank: s.rank,
    s_categories: s.categories,
    s_snippet: s.snippet,
    s_description: s.description,
    s_thumbnail: s.thumbnail,
    s_data_safety: s.data_safety,
    s_additional_information: s.additional_information,
    lookup_completed: 1
  }).eq('id', id).select();
  const { data, error } = await supabase.from('android_app_lookups').update({
    s_title: s.title,
    s_product_id: s.product_id,
    s_authors: s.authors,
    s_developer_contact: s.developer_contact,
    s_extensions: s.extensions,
    s_release_date: s.release_date,
    s_rating: s.rating,
    s_reviews: s.reviews,
    s_downloads: s.downloads,
    s_content_rating: s.content_rating,
    s_rank: s.rank,
    s_categories: s.categories,
    s_snippet: s.snippet,
    s_description: s.description,
    s_thumbnail: s.thumbnail,
    s_data_safety: s.data_safety,
    s_additional_information: s.additional_information,
    lookup_completed: 1
  }).eq('id', id).select();


And here is the error catch itself:
 } catch (err) {
    console.log({
      message: err?.message ?? err
    });
 } catch (err) {
    console.log({
      message: err?.message ?? err
    });


I've verified that there's data available to write to the table.

You can see in the screenshot that the table exists. Why would it kick this error, especially since it's succeeded before?
image.png
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

Return Error from Edge Function
SupabaseSSupabase / help-and-questions
4y ago
Query table from edge function
SupabaseSSupabase / help-and-questions
4y ago
Invoking Edge Function from Browser
SupabaseSSupabase / help-and-questions
4y ago
Error on calling edge function from react app
SupabaseSSupabase / help-and-questions
7mo ago