SupabaseS
Supabase•5mo ago
Grantly

Function uuid_generate_v4() does not exist (SQLSTATE 42883)

Getting Error:
Function uuid_generate_v4() does not exist (SQLSTATE 42883)

Is this just that we need add extensions before our use of uuid_generate_v4()? 
extensions.uuid_generate_v4()


Or would you actually create the extension?

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
SET search_path TO public, extensions;


I am a bit confused because, my migrations always worked, now they are having an issue?
I am also confused because I can see in my Dashboard that uuid-ossp is installed by default? If I am running a db reset, is it just "not aware" of that?

Thanks for any help!
Was this page helpful?