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.

I found that the issue was related to the extension

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;

I added the

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,

Supabase•4y ago•

1 reply

Pierre_

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.

I found that the issue was related to the extension

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;

I added the

cascade

cascade

How to reinstall `uuid-ossp`?

Similar Threads

How to reinstall `uuid-ossp`?

Similar Threads

Similar Threads

Similar Threads