Function uuid_generate_v4() does not exist (SQLSTATE 42883)

Getting Error:

Function uuid_generate_v4() does not exist (SQLSTATE 42883)

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()

extensions.uuid_generate_v4()

Or would you actually create the extension?

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

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!

Supabase•8mo ago•

1 reply

Grantly

Function uuid_generate_v4() does not exist (SQLSTATE 42883)

Getting Error:

Function uuid_generate_v4() does not exist (SQLSTATE 42883)

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()

extensions.uuid_generate_v4()

Or would you actually create the extension?

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

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

Function uuid_generate_v4() does not exist (SQLSTATE 42883)

Similar Threads

Function uuid_generate_v4() does not exist (SQLSTATE 42883)

Similar Threads

Similar Threads

Similar Threads