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 gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.