How to reinstall `uuid-ossp`?

Hello,

I have an issue with supabase storage. When I try to upload a file to a bucket, I get the following error message:
Database error: Failed to upload <file>: null value in column "id" of relation "objects" violates non-null constraint.

I found that the issue was related to the extension uuid-ossp. When I created the supabase project, I ran the following sql query:
drop extension if exists "uuid-ossp" cascade;
create extension if not exists "uuid-ossp" with schema extensions;

I added the cascade tag in the query above, because otherwise it wasn't possible to drop the extension, as other objects were depending on it.

However, I'm now running into the above issue when using supabase storage.

Is there a way to make things right again, or do I have to recreate a new supabase project from start?

Thanks in advance for your answer,
Was this page helpful?