How to fix issue uuid_generate_v1() does not exist in postgresql , actually i have the function under public schema
Apparently, the CREATE FUNCTION statement used a wrong search path. (This is not shown by \df.)

You can either tell the function to use the value in the environment, or set it explicitly to a correct value:

ALTER FUNCTION da.test_get RESET search_path;




ALTER FUNCTION da.test_get SET search_path = da, public;