Cannot run 'uuid-ossp' functions even when it's activated
There are several possibilities:


you ran CREATE EXTENSION in a different database (postgres?)
you installed the extension in a schema that is not on the user's search_path.


Use

\dx "uuid-ossp"


in psql to see where the extension is installed.