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.

Database error: Failed to upload <file>: null value in column "id" of relation "objects" violates non-null constraint.

Database error: Failed to upload <file>: null value in column "id" of relation "objects" violates non-null constraint.

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

uuid-ossp

uuid-ossp

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;

drop extension if exists "uuid-ossp" cascade;
create extension if not exists "uuid-ossp" with schema extensions;

drop extension if exists "uuid-ossp" cascade;
create extension if not exists "uuid-ossp" with schema extensions;

drop extension if exists "uuid-ossp" cascade;
create extension if not exists "uuid-ossp" with schema extensions;

I added the

cascade

cascade

cascade

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,

Pierre_OP•12/25/22, 7:37 PM

I ran the following query and it is working now:

alter table storage.objects
    alter column id set default uuid_generate_v4()

alter table storage.objects
    alter column id set default uuid_generate_v4()

How to reinstall `uuid-ossp`?

Similar Threads

Similar Threads

Similar Threads