© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•5mo ago•
57 replies
Damien

Error on storage Search

Hi everyone, an error just happened in production 'randomly' because no changes have been done, but I now can't see the storage content in the app but also in the supabase dashboard:

Failed to retrieve folder contents from "documents": select * from storage.search($1,$2,$3,$4,$5,$6,$7,$8) - function storage.search_v1_optimised(text, text, integer, integer, integer, text, text, text) does not exist
Failed to retrieve folder contents from "documents": select * from storage.search($1,$2,$3,$4,$5,$6,$7,$8) - function storage.search_v1_optimised(text, text, integer, integer, integer, text, text, text) does not exist


It seems that a change have been done from
storage
storage
to
app_storage
app_storage
.

I have tried to add back the search function, but anything I do tell me this:

ERROR: permission denied for schema app_storage (SQLSTATE 42501)
ERROR: permission denied for schema app_storage (SQLSTATE 42501)

But I try to do it as the
postgres
postgres
role...

Any idea on what to do or / and what is happening?
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

Similar Threads

Was this page helpful?
Recent Announcements
Next page

Similar Threads

Could not find storage.search
SupabaseSSupabase / help-and-questions
4y ago
Supabase Storage error
SupabaseSSupabase / help-and-questions
3mo ago
Supabase Storage Error
SupabaseSSupabase / help-and-questions
4mo ago
storage 403 error
SupabaseSSupabase / help-and-questions
8mo ago