CREATE OR REPLACE FUNCTION "public".test_uuid(gen INTEGER)
RETURNS UUID 
AS 
$$
 BEGIN
 FOR i IN 1..$1 LOOP
   RAISE INFO 'uuid = %', uuid_generate_v4();
  END LOOP;
 END;
$$
LANGUAGE 'plpgsql';

ALTER FUNCTION "public".test_uuid(gen INTEGER)
OWNER TO "lamauser";

 SELECT PUBLIC.test_uuid(1111111);

[Err] ERROR:  function uuid_generate_v4() does not exist
LINE 1: SELECT uuid_generate_v4()
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT uuid_generate_v4()
CONTEXT:  PL/pgSQL function test_uuid(integer) line 4 at RAISE


Affected rows: 0