Storage upload issue

I found where the issue comes from:

I created a new project to start from zero. Uploading files to storage was working well, unless I ran the following sql query:
drop extension if exists "uuid-ossp" cascade;
create extension if not exists "uuid-ossp" with schema extensions;

The extension uuid-ossp was initially installed, but this query drops it and adds it again. However, to drop the extension, the query must include cascade, otherwise it says that other objects depend on the extension.

So I guess the table storage.objects was using this extension to generate the value of the id command, so it was depending on the extension uuid-ossp, but the query uninstalled the extension and didn't reinstalled it well, so it is not working anymore.

The issue is that I disabled the extension but I should have.

How could I "restore" the extension to its "original state"?
Was this page helpful?