postgresqlubuntu-14.04

PostgreSQL function gen_random_uuid() not working

I get function get_random_uuid() does not exist error when running this SQL:

ALTER TABLE "posts" ALTER COLUMN "id" SET DEFAULT gen_random_uuid()

I can see pgcrypto module listed in this query select * from pg_available_extensions;. I'm using PostgreSQL 9.4.5 on Ubuntu 14.04.

Did I miss something?

Solution

  • Firstly, it's gen_random_uuid(), not get_random_uuid()