http://www.starkandwayne.com/blog/uuid-primary-keys-in-postgresql/
https://dba.stackexchange.com/questions/146135/psql-9-5-gen-random-uuid-not-working
psql 9.5: gen_random_uuid() not working?
SELECT gen_random_uuid()
produces output:
ERROR: function gen_random_uuid() does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.you can check if the functions are defined using:
select * from pg_proc where proname like ‘gen_random_%’;if both functions are not defined then you probably had an error with the extension creation – just drop it and recreate:
CREATE EXTENSION pgcrypto;